#error! field when field is balnk

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!

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'))
)
1 Like

Ahhh, I see. Makes sense.

thanks very much, that worked a treat

1 Like