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)?
-
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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!