What formula do I use to roll up statuses?

Hi everyone, I need help!

I have these 3 statuses, Not Started, In Progress, Complete

I am trying to create a formula which rolls up the statuses for example,

if all tasks are not started, parent status should be not started,

if atleast 1 task is in progress, parent should be in progress ,

and if all tasks are complete, then parent should be complete.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!