Formula to change status on anniversary

[Mark_Woolnough]

Good afternoon,
Hoping for some help please.

I have a status filed (single select). New / requested / quoted / complete etc

• Is it possible to have the status change automatically depending on information in other fields. i.e.

1. The status selects ‘New’ if another field B is empty
2. The status selects ‘Requested’ if field C is not empty etc etc

Thanks
Mark

[augmented]

Hi Mark. You can do this easily with an automation. If you get stuck, let us know.

Airtable Support

When a record matches conditions trigger

Overview Automations allow you to perform an action whenever a record fires the trigger for that automation.  When building an automation, the first step is to the choose the trigger that will star...