Page 109 - Customize-Project-Plan-by-tailoring-Smartsheet
P. 109
Customize your Project Plan
by tailoring Smartsheet
CASE STUDY
We get this column "Parent Level", place our formula there, draw the level of the hierarchy and then
assign colors through "Conditional Formatting":
More information on the internet:
https://help.smartsheet.com/learning-track/level-1-get-started/rows-and-hierarchy
https://community.smartsheet.com/discussion/98520/hierarchy-formula-
help?_gl=1*1qh653h*_ga*ODMxND-
QyNTI3LjE3MTQ3MzAyMDA.*_ga_ZYH7XNXMZK*MTcxNTI1ODQ4OC4xNS4xLjE3MTUyNTg4MTcuMzc
uMC4w
© Hans Porzel, 10/2025 | CAPM® (PMI), PSM I® (Scrum.org), Smartsheet Prod. Cert® 2020 Page 109 / 209 pages

