Help with Stacked IFs for Color Balls
=IF(Status@row="Complete","Blue",IF((AND[Actual Start Date]@row=[Start Date]@row,Status@row="In Progress"),"Green",IF(AND([Actual Start Date]@row<>[Start Date]@row,Status@row="In Progress"),"Yellow",IF(AND([Actual Start Date]@row<>[Start Date]@row,Status@row<>"In Progress"),"Red"))))
Tired eyes, I know I'm missing something can can't figure it out.
I am tried to have a symbol column that shows green, yellow, red, blue as follows:
1) when Status@row is "Complete" show blue ball
2) when [Actual Start Date]@row equals [Start Date]@row and Status@row is "In Progress" show green ball
3) when [Actual Start Date]@row is not equal to [Start Date]@row but the Status@row is "In Progress" show yellow ball
4) when [Actual Start Date]@row is not equal to [Start Date]@row, and Status@row is not equal to "In Progress" show red ball
Answers
-
It looks like you're missing an open parentheses after an AND, and you have extra parentheses after an IF! I've bolded the correction.
Try this:
=IF(Status@row = "Complete", "Blue", IF(AND([Actual Start Date]@row = [Start Date]@row, Status@row = "In Progress"), "Green", IF(AND([Actual Start Date]@row <> [Start Date]@row, Status@row = "In Progress"), "Yellow", IF(AND([Actual Start Date]@row <> [Start Date]@row, Status@row <> "In Progress"), "Red"))))
Cheers,
Genevieve
-
Oh! Thank you! Tired eyes get me every time!
Thank you so much😊
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!