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!