Tracking latest Changes for Helper Column
Hey all I need some help with tracking the latest changes in a row for my sheet. My sheet is going to have repeating update requests to track each shifts production levels every couple hours. The team leaders will update the row with the current production number at every interval. I want to have a helper column that will report a 1 if the row is in the current day. The issue is that with the modified column switching from a 1 (active) to a 0 (inactive) counts as a change, which updates the date/time and makes the row active again.
Once I have this set I'll use the helper to filter a report and the report to build charts on the current days information, which I already have done. The only issue is getting the identifiers correct.
I've posted a cut down version of the sheet below.
Any help is appreciated
Help Article Resources
Check out the Formula Handbook template!