Hello!
I wanted to know if there was a way to turn on/off a date stamp in a column when ticking a box (or a toggle, doesn’t matter). I have a column that has a “waiting” status (checkbox) for tasks. I’m trying to figure out if it’s possible to have a column in the same table that logs the time of click. I don’t want a last updated column, because if I change the title of the task, etc. it won’t show me how long a task has been “on hold” for.
I’m really crap a formulas, but my thought was something like - “if checkbox is true, insert timestamp. if checkbox is false, no timestamp.”
I only look at the column in a filtered table view, so that’s perfect. Thank you!