Hi,
I have a ticketing dashboard for orders that are unpaid and have a date of when it was entered. I would like to use a formula to highlight orders that are 60 days overdue, for example.
How would I do so?
Thanks,
Amanda
Hi Amanda,For each value, use Conditional coloring. Use > as the condition, and a formula like...
IF ( MAX ( DDIFF ( NOW( [Days in Date] ) , [Days in Date] ) ) >= 60 , -1 , NULL )
This will check whether the value is > -1 if it's been more than 60 days, or > NULL otherwise.
Hi Chris,
Thank you for the response! Is the formula input in the Values section for both? Or it's meant to be in the Rows?
In Values where you've underlined in your image...
Got it! Thank you very much.