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)
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list