Re: Does the formula function allow you to type in a blank cell?

565 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello everyone! I’m working on a project that involves air tables and was wondering if there was a way I could use the formula function and if the cell is blank, then type in it. My current code is this IF(OR({Implementation outcomes}=“No”, {Implementation outcomes}=“No”), “N/A”, IF({Implementation outcomes}=“Yes”, “”))

It works fine, but when I click on a blank cell to type the tool used it won’t allow me to write. Thanks!

1 Reply 1

Welcome to the Airtable community.

It sounds like you are used to using spreadsheets. As much as Airtable might look like a spreadsheet, it is not one. If a field/column is a formula field, you cannot manually enter values in any of the cells in that field/column, even if they are blank.