Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Overrideable Formulae / Default Value

cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Huggins
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Airtable.

I’d like the ability to override the contents of formulae-text cells with text of my own. I most commonly use this for record titling/naming. We use Airtable as a meeting/diary manager. So if we put in the people who attend, the formulate title could be “Roger meets David”, but we could override that title to become “Financial Planning Meeting 3”, say.

You can think of it as “overriding” or as “defaulting” but the point is that there are lots of time when i want formula-based default titles which can be changed to something else later.

12 Comments
Luke_Chapman
4 - Data Explorer
4 - Data Explorer

Let’s say Column C = your formula column

  1. Make Column B your “Manual Override” column
  2. Make Column-A a formula that says: If Column B isn’t empty then return Column C.
  3. Hide Column C

Now you’ll have your Formula Results Column (A) - and when you want to make an edit, you modify the ‘blank cell’ in column B. It is a bit hacky, but would accomplish what you want.

scottandrews926
4 - Data Explorer
4 - Data Explorer

Smartsheet allows this and I am disappointed that Airtable does not...