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

Customize your Project Plan
   
by tailoring Smartsheet

=SUMIF({P-1001 Power Drivelet Range 1}, Department@row,..........)

=SUMIF({P-1001 Power Drivelet Range 1}, Department@row, {P-1001 Power Drivelet Range 2})

Result: Check:

Just for your information: If you would like to take into account more than one (1) criterion, then
please apply the function SUMIFS.

Internet: https://www.youtube.com/watch?v=6d9UiQJ3SEQ

To be honest, however, I have to admit that this solution ("Roll-Up sheet") is often better done with a
report. We'll talk about reports in the next chapter.

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