Complicated if statement - health column
Hi All,
I'm really hoping you can help me.
We have a project tracker that has below columns:
Client Type (platinum, gold or silver), Delivery Date, Aging, Status, Health.
The health column is a symbol column with green, yellow and red colours. We need the formula to indicate the below requirements:
I've been trying for days now but can't come up with such formula so any help would be much appreciated here please!
Answers
-
Are you entering the priority as well or just the priority description? Are you able to provide a screenshot of the source data (sample data can replace confidential data as needed)?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi @angelapaj,
Try this:
=IF(Priority@row = 1, "Red", IF(Priority@row = 2, "Red", IF(Priority@row = 3, "Yellow", IF(Priority@row = 4, "Yellow", IF(Priority@row = 5, "Yellow", IF(Priority@row = 6, "Green", IF(Priority@row = 7, "Green", IF(Priority@row = 8, "Green", IF(Priority@row = 9, "Green", IF(Priority@row = 10, "Green", IF(Priority@row = 11, "Green", IF(Priority@row = 12, "Green", IF(Priority@row = 13, "Green", "")))))))))))))
You can simplify this further, but leaving like this will make it easier to edit later if you need to adjust.
-
@Paul Newcome I have only been entering the priority description.
-
Ah. I think I see what is going on. In the screenshot of your table "Gold & Aging & Review" is not an actual status. It is a combination of columns you want to evaluate to output the color? If that is the case, which column is "Aging", and how do we determine yes/no?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!