How to highlight a partner when a value is reached
Hi Team,
I was wondering if anyone has an idea how to highlight a cell when a partners reward value exceeds a Dollar amount?
I currently have a sheet that is updated from an external source on a fortnightly basis that shows clients invoice values. From this data I have a formula that calculates a reward amount on the same sheet to the right using some basic formulas.
From this I have a report that shows the partners name and the reward amount, but it wont let me "sort" by the reward value descending as its grouped by reseller name.
One option I have explored was to have a second sheet to "summaries" the reseller name and rewards value and create a sort of Pivot table but haven't been able to get this to work as the source data change.
Any thoughts?
Daniel
Answers
-
Hi @Daniel Stuckey,
You could use conditional formatting to highlight the cell visually. The conditional formatting you set on the source sheet will carry over to the report.
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!