Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
1123 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Joel_Chavez_Ort
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.