IF formula to delete a row

I have a sales pipeline on Airtable with a single select field for the different stages. e.g. Qualified Lead, Initial specification, Evaluate quote, WON etc.

At the moment I have a filter on the table so if the project is WON it is flitered out of the pipeline.
However I would like to create a formula whereby

IF {STAGE} = “WON” then the row is deleted from the table

Is this possible?

You should just use a filter to remove it from a view.

1 Like

‘Hide’ :stuck_out_tongue_closed_eyes:.

In fact, seem is already doing it:

I think keep the record and hide it with the filter is better, so you don’t lose information. If you want to delete it anyway, you can automate it with 3rd party tools like Integromat.

1 Like

Or you could have a view filtered for projects that have been WON, and then periodically delete all the records in that view. An automated process has the danger of accidentally deleting a record without realising it.

1 Like

Yes, I think you are both right, thinking about it. It could be very annoying if something is changed to WON by mistake and then all that information disappears! :cry:

I’ll leave it as a filter

Thank you!