Hi Johnny,
Just my idea on this, so let me summarize what I get from your case:
- You have 1 column for a timestamp of the “initial change”
- You have 1 column for any further changes, which will record the last time the status was changed
- You have 6 checkboxes and need any edits in Glide reflect in the timestamp change in the sheets.
How about writing a script that:
- Takes the timestamp from any change. If column of initial change is empty, record it to that column, let’s call it column A.
- If column A is not empty, we then move to column B of further changes. Simply record the newly taken value to column B, whether it already had value or not (because you want to take the latest change timestamp).
Another note is it seems that onEdit does not work, as you may have noticed, but onChange does, as the people in this thread said.