Using formulas to determinate the status of a set of tasks

Miguel Bravo
Miguel Bravo ✭✭
edited 12/09/19 in Formulas and Functions

Hi community, 

I'm new on Smartsheet and I'm trying to make a formula to automatically calculate the status of a set of tasks (or subtasks).

Let me explain my situation: I've created a main task, lets say "Project1" and it contains some subtasks as children. Next to this first column, I've got a column for the status (its type is dropdown and I've defined it with a set of values ["Waiting", "Started", "Ongoing", "Finished", "Closed"].

My query is if I can automatically set the value of "Project1" status based on the status of the childrens. As I first approach, I would like to set the status as "Ongoing" if any of the childre are in "Ongoing", and "Closed" if all the children are "Closed".

I'm trying with any of the combinations in the template, but none of them uses Dropdown list values, and any of the following formulas return error messages:

=if([Project1]1=Closed) --> #UNPARSEABLE

=if[Project1]1='Closed) --> #UNPARSEABLE

=if[Project1]1="Closed") --> #INCORRECT ARGUMENT SET

 



Can you please help me?

Thanks in advance

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!