Hello everyone, I have a board with an expiration date (not deadline) that our Human Resources employee must update manually, and I have a status column that I want to automatically reflect the status of the entered date.
I was able to manage all possible status (60 days to the expiration date, 30 days to the expiration date, the expiration date arrives), except one that is when the Human Resources employee enters a renewed expiration date and I need that the status column automatically turns green (UPDATED).
There is no way to do it, because monday.com obviously does not know the renewed date until the Human Resources employee enters this date in the date column. Then, the Human Resources employee has to change the status column manually in green (and I really don’t like it at all).
So, I went in circles thinking about how to do it, until I found this automation:
Is there a short-term possibility of making this automation available to make a change of status instead of notifying people? With that I can detect when a change is made (assuming a good date is entered) and change the status to green.