Fast status updates based on parent cell
I would like to make our status updates faster by utilizing the parent/child cell(s).
If the user changes the status in the parent cell (dark grey line) to "Completed" then the child and grandchild cells would change to completed.
If the user marks the child cell as one of the following statuses then the grandchild rows would reflect then same status, but users can change the grandchild status manually.
Example: =IF([Parent]4 = "Completed", "Completed", IF([Parent]4 = "Backlog", "Backlog", IF([Parent]4 = "Blocked", "Blocked", IF([Parent]4 = "In Progress", "In Progress", IF[Parent]4 = "", ??? ))))
If parent cell is blank then do nothing ... meaning use what is manually selected on the cell
** Note: We report based on the grandchild task. But as I said I want users to be able to change the status easily.
** Parent Row is dark grey, child is light grey and grandchild is white. **
Answers
-
You won't be able to do this with formulas directly. You would have to set up helper columns with formulas on the appropriate rows to trigger some Change Cell automations.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!