Looking to track cleanings
Currently I'm looking to add a validation mechanism to a sheet and would like to have a systems that reports after (X number of) cleanings have been completed for the day. This would add a row displaying the room that was complete for the day. If the room was not complete it would show up in red as not complete.
I'd also like the time the cleaning log was reported to be a separate row not attached to the date like the modified date shows. Currently it shows up as [ 09/29/23 8:21 AM ] I'd like it to show up in two different columns.
Thanks for the assistance.
Help Article Resources
Check out the Formula Handbook template!