How to highlight a partner when a value is reached

Daniel Stuckey
Daniel Stuckey ✭✭✭
edited 12/29/21 in Formulas and Functions

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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!