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

Mik

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!

Andrée Starå

Hi Mik,

Unfortunately, it's not possible at the moment because there isn't a formula that can Indent/Outdent, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD