Symbols Based on Value
I am creating a P&L Sheet to evaluate Job Profitability. I want to have two columns where symbols (Red, Green, Yellow, Blue) will show the Job Health. The first column will show symbols based on the Labor Profit Health, and the Second will be based on the Total Project Health.
I would like the colors to meet the following parameters For the Labor Health:
Labor Profit % > 25% - Green
Labor Profit % between 25% and 20% - Yellow
Labor Profit % < 19% - Red (including negative percentage)
Labor Billed = 0 – “Blue”
I would like the colors to meet the following parameters For the Total Project Health:
Total Profit % > 25% - Green
Total Profit % between 25% and 20% - Yellow
Total Profit % < 19% - Red (including negative percentage)
Total Billed = 0 – “Blue”
Any help would be appreciated
Answers
-
Hello @Micah Turner
If I'm understanding your question correctly something like this should help
First ensure the "Status" or Health Columns have the Symbol Properties you desire:
Then have the Columns with Percentages in Percentage Format.
Lastly this formula. You can modify it to suit your needs better if needed.
=IF(Percentage@row > 0.24, "Green", IF(Percentage@row > 0.19, "Yellow", IF(Percentage@row = 0, "Blue", IF(Percentage@row > -0, "Red", "Red"))))
Let me know if you found this helpful!
https://www.linkedin.com/in/zchrispalmer/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!