Making a formula to clear data

[Ashley_Bunner]

Hello,

I am still very new to Airtable so maybe this is easier than I think but would still like help.

In general, I am looking to write a formula so that when a field (that is a single select option) is selected to “deleted” it will then clear many fields (that are multiple select) of all of their data.

So in the picture included below, when the field Deleted is selected to “Deleted” I want all of the data in the other rows to be cleared and back to like nothing had been selected.

How would I go about this?

Thanks

[kuovonne]

Formula fields cannot change the values in editable fields.

You could use an automation that would check for when field {Deleted} has the value “Deleted” and then clear the values of the editable fields.