Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Making a formula to clear data

Topic Labels: Formulas
469 1
Showing results for 
Search instead for 
Did you mean: 


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.