Formula to Roll Up Task Status
I am looking for some help with a formula that I haven't been able to find in the community already.
I'd like to roll up my Status column to the parent rows with the following conditions:
- Parent shows as Not Started if: All children are either Cancelled or Not Started.
- Parent shows as In Progress if: Even one child is In Progress.
- Parent shows as Complete if: All children are either Cancelled or Complete.
- Parent shows as Cancelled if: All children are Cancelled.
- Parent shows as On Hold if: All children are either Cancelled or On Hold.
One other "feature" that would be helpful is if I was able to make it a column formula and have it only apply to parent rows (I know there needs to be an IF PARENT in there somewhere).
Help Article Resources
Check out the Formula Handbook template!