Hi all,
I'm using this query that writes today's date into a cell in column P (15) when I tick a check-box in the same row. If I untick the check-box, the date is deleted again.
All working great, however, how would I need to tweak the query to
1. Still write the date to column P, whenever,...
2. ...any content changes in a defined range in the same row (let's say column A to Column O), and...
3. ...delete the date again if the same range does not contain any content (i.e. cells are blank)?
Hope anyone can help. Quite a newbie to GoogleSheets and spend hours trying it myself (e.g. using if(e.value == null) etc, but no luck, yet) :-(
Many thanks!
Bookmarks