Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

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

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.