Trova informazioni su tutto ciò che riguarda Smartsheet – dalle migliori pratiche di gestione dei progetti a preziose guide pratiche fornite da altri utenti ed esperti di Smartsheet.
Accedi per fare la tua domanda sulla formula o partecipare a una discussione.
Dai un'occhiata all'elenco di tutte le funzioni disponibili in Smartsheet.
Scarica il Manuale delle formule con oltre 100 formule ed esempi nel foglio.
Un articolo con funzioni usate frequentemente e risorse aggiuntive.
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)