Is there a way to make a colum in Google Sheets / Appsheet that is related to changes on the row level.
For Example: If I have a Sheet called โTasksโ and theres
Task name, tasks description, status, due date, last_update
some_task, some descp, backlog, 11/20/2021, 11/18/2021 12:55:00
and if I were to change the status to โIn progressโ the โlast_updateโ column would automatically update to todays day and time value, so then it would read:
some_task, some descp, backlog, 11/20/2021, 11/19/2021 12:57:00
Thank you!
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |