Hello the community !
I have a table with a date field. I have a formula which is :
IF(IS_AFTER(TODAY(),{Date}), ‘Published :rocket: ’, ‘To publish :hourglass_flowing_sand: ’)
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 :rocket: ’, ‘To publish :hourglass_flowing_sand: ’” ?
Sorry for my english…
Thank you very much !
Best answer by Mohamed_Swella1
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 :rocket:’, ‘To publish :hourglass_flowing_sand:’)
BR,
Mo
+17Hi @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 :rocket:’, ‘To publish :hourglass_flowing_sand:’)
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 :rocket:’, ‘To publish :hourglass_flowing_sand:’)
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 ?
+17Oh 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 :slightly_smiling_face:
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 :rocket:’, ‘To publish :hourglass_flowing_sand:’))My pleasure :slightly_smiling_face:
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 :rocket:’, ‘To publish :hourglass_flowing_sand:’))It’s really perfect, thank you Mohamed !
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.