Finden Sie Informationen zu allem, was mit Smartsheet zu tun hat – von bewährten Methoden im Projektmanagement bis hin zu unschätzbaren Anleitungen von anderen Nutzern und Smartsheet-Experten.
Melden Sie sich an, um Ihre Formel-Frage zu stellen oder an einer Diskussion teilzunehmen.
Sehen Sie sich eine Liste aller verfügbaren Funktionen in Smartsheet an.
Laden Sie das Formel-Handbuch mit über 100 Formeln und Beispielen im Blatt herunter.
Ein Artikel mit häufig genutzten Funktionen und zusätzlichen Ressourcen.
What are Smartsheet Functions?
How do I add numbers from two columns together in Smartsheet?
Are Smartsheet functions the same as the Excel functions?
How can I join numbers or text from 2 cells into one with a formula?
Is it possible to combine multiple cells and add in a symbol, such as |, between two sets of data? The excel formula being used is: =IFERROR(CONCAT($A7,", ",$B7," | ",$D7),) Second formula is: =IFERROR(CONCAT($A7,", ",$B7," | ",$D7," | COMPANY"),) Third is for alt text tags: =IFERROR(CONCAT(SUBSTITUTE($A7,"…
I cannot use the concatenate formula in SmartSheet the same way as Excel. I am trying to input the Location Number into the email so that it reads "st[Location Number]manager@.com" as shown in the screenshot here. Is there a way to do this inside SmartSheet?
When I use a concatenate formula to combine a Date and Time to create an individual code, the Date appears in the default format 01/01/25 but the date in the Column it is referencing is formatted 2025-01-01 which is how I need it to appear in the result. How can get the Concatenate formula to just reproduce the Date format…
I want to concatenate 2 numeric columns into another numeric column. Taking Year and Month into YEARMONTH where YEARMONTH is still a number and not text. 2023 and 07 as number 202307
Why isn't this working: =COUNTIF(Column Name: Column Name)