'How to change cell value based on today's date in Google Sheets
I have a table like this one, but I'm looking to automate the change of status when a given date is reached. I've looked into setValue(), but I still need your help to make it work 😅: I'm more or less desperately trying to write something that will change 'Status' to 'Terminated' when today's date match with the one in 'End'.
Thank you for your help!!!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|