Skip to main content

Hello the community !


I have a table with a date field. I have a formula which is :

IF(IS_AFTER(TODAY(),{Date}), ‘Published 🚀 ’, ‘To publish ⏳ ’)

And it’s working fine.


Now, I have 3 différent dates for 1 record. So I have a 3 date fields : ‘Date1’, ‘Date2’ and ‘Date3’

What are the formula for “If Date1 or Date2 or Date3 are not empty, then ‘Published 🚀 ’, ‘To publish ⏳ ’” ?


Sorry for my english…


Thank you very much !

Hi @Quentin_Guestin,


Welcome to Airtable Community! :grinning_face_with_big_eyes:


You need an IF OR formula. So the formula would be


IF(OR(IS_AFTER(TODAY(),{Date 1}), IS_AFTER(TODAY(),{Date 2}),IS_AFTER(TODAY(),{Date 3})), ‘Published 🚀’, ‘To publish ⏳’)


BR,

Mo

Hi @Quentin_Guestin,


Welcome to Airtable Community! :grinning_face_with_big_eyes:


You need an IF OR formula. So the formula would be


IF(OR(IS_AFTER(TODAY(),{Date 1}), IS_AFTER(TODAY(),{Date 2}),IS_AFTER(TODAY(),{Date 3})), ‘Published 🚀’, ‘To publish ⏳’)


BR,

Mo


Oh my god, thank you so much ! It’w working !

And one detail, if I want an empty cell when all date field are empty, what I suppose to write in the formula ?

Oh my god, thank you so much ! It’w working !

And one detail, if I want an empty cell when all date field are empty, what I suppose to write in the formula ?


My pleasure 🙂


As for the empty cells, you can do this:


IF(AND({Date 1}=BLANK(),{Date 2}=BLANK(),{Date 3}=BLANK()),BLANK(),

IF(OR(IS_AFTER(TODAY(),{Date 1}), IS_AFTER(TODAY(),{Date 2}),IS_AFTER(TODAY(),{Date 3})), ‘Published 🚀’, ‘To publish ⏳’))

My pleasure 🙂


As for the empty cells, you can do this:


IF(AND({Date 1}=BLANK(),{Date 2}=BLANK(),{Date 3}=BLANK()),BLANK(),

IF(OR(IS_AFTER(TODAY(),{Date 1}), IS_AFTER(TODAY(),{Date 2}),IS_AFTER(TODAY(),{Date 3})), ‘Published 🚀’, ‘To publish ⏳’))

It’s really perfect, thank you Mohamed !

Reply


Terms & Conditions