Help with Formulas
Hello!
I’ve been using Smartsheets for a while now, but am new to building them. I am having trouble working with formulas to identify current status of my tasks. I’ve searched the community and have tried out suggestions based on previous responses, but I’m still stuck.
I’d be grateful for help sorting out the following:
- What formula should I use to enable status health balls for each individual line (lines 5-7) to auto populate based on current status and overall due date?
- What formula should I use to enable the parent line (line 4) status health ball to auto populate based on the overall status of the individual lines within the group?
Ultimately, I'd like the status of each parent item to populate a report that I've created.
Thanks very much!
Comments
-
You would use nested IF statements for both.
For the child rows, it would look something like this...
=IF(Criteria set 1 is true, "Red", IF(Criteria set 2 is true, "Yellow", IF(Criteria set 3 is true, "Green")))
For the parent rows it would look something like this...
=IF(CONTAINS("Red", CHILDREN()), "Red", IF(CONTAINS("Yellow", CHILDREN()), "Yellow", IF(COUNTIFS(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green")))
.
The specifics would be based on your exact criteria.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.9K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!