How to flag a total in a report that exceeds a limit?
I am trying to figure out a clever work around to the limitation of referencing reports in formulas. We have numerous independent schedules.... I compile certain tasks from each schedule, for example "drawing releases", into a single report. I want to be able to monitor the grand total from the report relative to a limit – if the limit is exceeded I would highlight on a dashboard.
The report has the exact data I need and a sheet has all the "limits".... if i could get the report to a sheet I could make it work.
Datamesh almost works... if it would delete rows. Pivot almost works if I could lock rows. I could brute force it by linking cells but that is not sustainable.