Formula to Outdent a row, when a certain status is reached

edited 12/09/19 in Formulas and Functions

Hi all, 

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!