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

Customize your Project Plan
   
by tailoring Smartsheet

A quick glance of the column shows that when you click on a cell in this column, then there
are three different symbols displayed.

Of course, it would be too cheap to select the symbols only manually. So, we want Smartsheet to
automatically draw our attention to whether the slack time is still in the "green area", whether we
might only have a few days left, e.g., 5 calendar days, so "yellow", or whether we have already ex-
ceeded the deadline at our planning, then the "red traffic light" would be displayed.

We solve the issue by boxing / nesting the IF function. Just by the way, concerning German, the IF
function would be still the IF function also when in German language IF is called WENN.

To avoid irritating us in our next proceedings, through the solution of our former done conditional
formatting, we deactivate it now temporarily. We do this by clicking "Disable Rule".

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