Page 84 - Customize-Project-Plan-by-tailoring-Smartsheet

Customize your Project Plan
   
by tailoring Smartsheet

29. Formulas (IF, VLOOKUP, …)

29.1. Formulas

Calculations and math operations can be carried out by formulas, similar to what you are probably

already know from Microsoft Excel .
As you certainly remember, we already worked more or less with formulas further up (IF, AND, etc.).

Just as a reminder, one of the formulas was: =IF([slack time]@row < 0, 1, 0)

Then we had already discussed a second formula. Just as a reminder again, that formula was:

=IF([Slack Time]@row > 5, "Green", IF(AND([Slack Time]@row < 5, [Slack Time]@row > 0), "Yellow",
IF([Slack Time]@row < 0, "Red")))

It looks complicated, but it isn't, if you know what the function does and how the terms and arguments
are involved. Recently we mainly worked with the function IF, which we boxed / nested a few times.

Usually, formulas use functions, or call them "command words", that perform a specific calculation.

However, as already mentioned further up about Country Settings, functions in Smartsheet are gener-
ally always in English, e.g., what is a WENN in German, then this is still an IF in Smartsheet, no matter
which language setting you have chosen.

More information on the internet:
You can look up all Smartsheet-Functions, even with profound samples at "Functions List |
Smartsheet Learning Center":

https://help.smartsheet.com/functions?_ga=2.157435770.1961333022.1657286579-
1312809393.1646983234

Smartsheet did here a real great job! https://www.smartsheet.com/about

Or as well learn more or ask questions at the Smartsheet Community:
https://community.smartsheet.com/?_gl=1*tocpnk*_gcl_au*NjYwMjA1ODE-
uMTc1NjE0NDk2Nw..*_ga*MTE4NjIxNjcyNC4xNzMx-
ODU0NTk5*_ga_ZYH7XNXMZK*czE3NTY0NTY3ODgkbzEzMiRn-
MSR0MTc1NjQ1NjgxMSRqMzckbDAkaDA.

© Hans Porzel, 10/2025 | CAPM® (PMI), PSM I® (Scrum.org), Smartsheet Prod. Cert® 2020 Page 84 / 209 pages