Date on switch

Hey, I use the toggle switch.

I want to create two columns,
In the first column I want to record
Timestamp when I toggle to (True) and want to record in the second column
timestamp when result becomes (false)

Is there any way to do this?

You can do that not with a toggle, but with a button.
It’d have a compound action, one is changing from empty to true on your 1st column, and a the 2nd action would be timestamping the interaction.


Yes, with button i know, but is there a trick with switch?

Only way, if you’re using Google Sheets, is using AppScript to look for the changes on the specific boolean column and record the timestamp of that change in another column.

1 Like