I have a sheet that others update as and when they can as well as reporting by set dates. A checkbox is used to mark that the material is cleared for reporting and this is the criterion that pushes the information through to dashboards and paginated reports. Managed previously with a single checkbox that was cleared on a certain date for reporters and reinstated on a deadline to push information through to dashboards and printed reports.
Management now wants a way to see the last cleared entry (and date) at any time.
Task | Status | DateModified(Auto) | Clearedfor Report(checkbox) |
|---|
Room A | Cleaned | Last modified: 01/06/2025 | Ticked |
Room B | Under repair | Last modified: 30/09/2025 | |
What's the best practice for handling this type of 'rolling' of text clearance? My formulas to date check whether the box is ticked and exclude those that aren't. Including date modified in paginated reports will be possible but messy.
