Column Status Formula
Options
aguillot
✭
Hi Everyone,
I have a status column with the following options: Not Started, In-progress, Complete, N/A.
I've created a formula if the parent row is set at 'Not Started' then the sub-task would automatically change to 'Not Started'. Same with Complete and N/A.
In-progress needs to work a little differently. The parent row may be in-progress where a sub-task may be complete or N/A.
When In-progress is selected it changes all the sub-tasks to blank. Is there a formula that would allow the sub-tasks to remain unaffected if the parent row changes to in-progress?
Best,
Ashlie
Tags:
Comments
-
I figured it out! The parent row doesn't change the sub-task when a specific drop down is selected first.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!