Hey all!
Currently, I have a client database with start date {start} and finish date {finish} fields.
Once I have added a finish date, I then manually update the {status} field from 'In Progress' to 'Done' - it is a single-select field).
However, I'd like to automate the above process, meaning I'd like to automate the following:
If {finish} is not empty (meaning a date has been selected and the project has been completed), change the {Status} field from 'In Progress' to 'Done'
I've attempted to do this but the automation comes back as an error.
I look forward to hearing any ideas!
