Formula to Outdent a row, when a certain status is reached
I've been using Smartsheet for a while now, love it, but I'm a bit rubbish with formulas.
I'm trying to have tasks 'de-parent' from its parent task (Outdent to '0') when a certain status is set.
I got to this formula (to no avail, but to help illustrate what I'm on about):
=IF(Status143:Status159)="COMPLETE (any/all)", ([Task Name]144:[Task Name]158ANCESTORS()) = 0)
(Note the '(any/all)' within "COMPLETE (any/all)" is just part of the name of the actual status)
Reason I'm doing this is I'm wanting the tasks under a card to clear off that card once they're complete
Thank you in advance!
Help Article Resources
Check out the Formula Handbook template!