#error! field when field is balnk

Topic Labels: Formulas
1431 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

New to airtable and formula’s so this should be easy for you but Im having brain fart moment!

I an trying to get a column to populate the following monday date once a date field is entered into the Listed column.

using this formula:


I get the desired monday result but all the other cells contain #error! ( assuming its because the listed column cell for that row is blank)

Tried using BLANK but I just cant get my head around it to get rid of the #error!

Thanks all!

2 Replies 2

Welcome, @Micheal_Ward!

Just wrap your whole conditional in another conditional that checks for the presence of a value in the {Listed} field before running the desired function.

6 - Interface Innovator
6 - Interface Innovator

Ahhh, I see. Makes sense.

thanks very much, that worked a treat