Using formulas to determinate the status of a set of tasks
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
Help Article Resources
Check out the Formula Handbook template!