Skip to main content

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

)

Ahhh, I see. Makes sense.


thanks very much, that worked a treat

Reply


Terms & Conditions