Help

Re: #error! field when field is balnk

792 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Micheal_Ward
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:

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'))
)
Micheal_Ward
6 - Interface Innovator
6 - Interface Innovator

Ahhh, I see. Makes sense.

thanks very much, that worked a treat