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

Customize your Project Plan
                                                                                                            
                                                                               by tailoring Smartsheet


               Columns / fields are there: a) "Department", b) "Net Duration Hours". Then we will sum-up the hours
               from our project plan.



















               The solution will be accomplished by the function =SUMIF(range,criterion,sum_range). The next
               screenshots show how to perform this step-by-step.























































               © Hans Porzel, 10/2025 | CAPM® (PMI), PSM I® (Scrum.org), Smartsheet Prod. Cert® 2020                                             Page 149 / 209 pages
   144   145   146   147   148   149   150   151   152   153   154