Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

#error! field when field is balnk

Topic Labels: Formulas
563 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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:

IF(1-WEEKDAY({Listed})<=0,DATEADD({Listed},1-(WEEKDAY({Listed}))+7,‘days’))

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.

IF(
   {Listed},
   IF(1-WEEKDAY({Listed})<=0,DATEADD({Listed},1-(WEEKDAY({Listed}))+7,'days'))
)

Ahhh, I see. Makes sense.

thanks very much, that worked a treat