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

Mik
Mik
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!

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!