Color Coding Formula
![Carlos Yanes](https://us.v-cdn.net/6031209/uploads/userpics/GJAQ9SLDSYK2/nUWI1W2E5ZEZ4.jpg)
Hey all,
Need some help with putting together a formula that will display color coding in a symbol column based on conditions being met in two other columns.
Under status there are the following options - Completed, In Progress, Not Started, On Hold. I'm trying to get the color coding to function as follows -
If Completed = color code health column as Green (will be using symbol colors)
If In Progress and the Estimated Launch Date is in the future from today's date then Green
If In Progress and the Estimated Launch Data is in the past then it should be Red
If On Hold then Yellow
If Not Started then Gray
Best Answer
-
You could do this with conditional formatting if you want without having to have the extra column or develop a formula
=IF(OR(Status@row = "Completed", AND(Status@row = "In Progress", [Estimated Launch Date]@row > TODAY())), "Green", IF(AND(Status@row = "In Progress", [Estimated Launch Date]@row < TODAY()), "Red", IF(Status@row = "On Hold", "Yellow", IF(Status@row = "Not Started", "Grey"))))
Answers
-
You could do this with conditional formatting if you want without having to have the extra column or develop a formula
=IF(OR(Status@row = "Completed", AND(Status@row = "In Progress", [Estimated Launch Date]@row > TODAY())), "Green", IF(AND(Status@row = "In Progress", [Estimated Launch Date]@row < TODAY()), "Red", IF(Status@row = "On Hold", "Yellow", IF(Status@row = "Not Started", "Grey"))))
-
Thank you! This worked perfectly.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!