Trouvez des informations sur tout ce qui concerne Smartsheet – des meilleures pratiques de gestion de projet aux conseils pratiques inestimables de la part d'autres utilisateurs et d'experts Smartsheet.
Connectez-vous pour poser votre question sur une formule ou rejoindre une discussion.
Consultez la liste de toutes les fonctions disponibles dans Smartsheet.
Téléchargez le manuel des formules avec plus de 100 formules et exemples intégrés.
Un article avec des fonctions fréquemment utilisées et des ressources supplémentaires.
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)