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).