Sign in to ask your formula question or join a discussion.
Check out a list of all the available functions in Smartsheet.
Download the Formula Handbook with 100+ formulas and in-sheet examples.
An article with frequently used functions and additional resources.
What are Smartsheet Functions?
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)