So everyday my coordinators fulfill a google spreadsheet with some tasks and then write in Column F “Done”.
Now I want to put a timestamp when the “Done” is achieved, for this I would put a column writing today() if Done is written then ifempty no today() would be applied, I want to run this report everyday, so the days different is fine to me.
Is there any way of “hard” writing the timestamp. Or as workaround I should make a export everyday to a CSV/TXT and then make a merge of all these daily files?
Thank you very much.