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.

Please Login or Register  to view this content.
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!