Skip to main content

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

  • February 8, 2021
  • 1 reply
  • 15 views

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

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • February 8, 2021

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.