Dynamic Conditional Format - Sumo Card

I'd like to be able to write conditional formatting rules in a sumo card beyond just a hard-coded number. For example, use the number in the 'total' row for a given column, rather than typing in a static value. 

 

Here's an example of when I would need this. If I have a calculated field (Cost per click, for instance) in my sumo card, then the total will not necessarily be a "sum" total of the numbers above it - rather it will be a calculation of another sum totaled column (cost) divided by another sum totaled column (clicks). So - some cost per click values will be greater than the total, and some will be less than the total. I'd like to be able to place conditional formatting rules on that column that look at the number in the 'Total' row, rather than a hard-coded number. For example, if less than the total, highlight in green, if greater than the total, highlight in red. Since my cost per click is changing every hour, the conditional format needs to be dynamic.

 

Thank you for your consideration!

3
3 votes

· Last Updated

Comments

This discussion has been closed.