Page 86 - Customize-Project-Plan-by-tailoring-Smartsheet
P. 86

Customize your Project Plan
                                                                                                            
                                                                               by tailoring Smartsheet


                      29.1.1.        IF



               • The principle / the syntax of the function IF is   =IF(CONDITION, THEN, ELSE)

               Example:

                             =IF(Duration@row = 0, "Milestone", "")

               • Text is supposed to be put into straight quotation marks (e.g., "milestone")

               • Quotation marks with no text in-between them, e.g., "", stands for ... <empty/nothing>


               • IF can be unlimited boxed / nested up, there is just the limit of 4,000 characters of the cell. But to
               get not confused by these many boxings, maybe the VLOOKUP function might than help.


















               More information on the internet:
               https://help.smartsheet.com/function/if


















                          IF

                                                               THEN


                                        ELSE






               © Hans Porzel, 10/2025 | CAPM® (PMI), PSM I® (Scrum.org), Smartsheet Prod. Cert® 2020                                             Page 86 / 209 pages
   81   82   83   84   85   86   87   88   89   90   91