Making a formula to clear data

Topic Labels: Formulas
923 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


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?


Screen Shot 2021-11-11 at 12.30.43 PM

1 Reply 1

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.