Status Column updating for Parent
I have a column "Current Status" that is filled in for each child row. I would like to automate the parent row showing in the following order
If "In Progress" appears for any child, then show "In Progress" for the parent
If "On Deck" appears for any child, then show "On Deck" for the parent
If "Manage" appears (but no on deck or in progress) then show "Manage"
Best Answer
-
Try something like this...
=IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIFS(CHILDREN(), "On Deck") > 0, "On Deck", "Manage"))
Answers
-
Try something like this...
=IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIFS(CHILDREN(), "On Deck") > 0, "On Deck", "Manage"))
-
Perfect, thanks Paul - I was so close with what I had tried!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives