I saw a post with the following formula: IF(IS_BEFORE({Due Date}, TODAY()), “ :boom: ”, " ") This formula puts the emoji in a column if the due date for something is past. I’m not really good with formulas. Is there a way to make it have that emoji if it is ON the due date AND after?
Solved
Formula help for due dates
Best answer by Jeremy_Oglesby
Thank you! How would I also make it blank if there was no date in the due date column? I’m lost on all of the parenthesis and extra quotations and what they mean. I will have time to go research that one day, i hope…(but for now, i gotta make just this work).
Also, where do you get the emojis? (when on a Windows desktop).
Hi @Brandi_Mills,
You should be able to use something like this:
IF(
{Due Date},
IF(
OR(
IS_SAME(TODAY(), {Due Date}, 'day'),
IS_AFTER(TODAY(), {Due Date})
),
"💥"
)
)
This will first check for any value at all in the {Due Date} field – IF( {Due Date} ... . If the field is empty, then execution will stop and nothing will be output.
If any value at all is found in the {Due Date} field, then it will continue to process the next conditional. Inside that, we make an OR() condition. If either one (IS_SAME() or IS_AFTER()) comes back as true, then it will output the emoji, otherwise it will not output anything.
So the end result of this is either an 💥 emoji if the due date is today or past, or else a blank cell.
I prefer to use Airtable’s explicit Date functions like IS_SAME() and IS_AFTER() rather than comparing dates with math operators like < or >= because I feel it makes the formula more clear to future readers. That’s just personal preference, though.
Also, here’s an explanation of how to access the emoji picker in Windows:
How To Use Emojis On Windows 10 (Updated 2017)
Color emojis are supported natively on Windows. This is how to use the built-in emoji picker in Windows 10 Fall Creators Update which is new in 2017. Note: Windows 10 Fall Creators Update is due for release in the second half of 2017. Windows...
+3You can see if today is greater than the due and apply the emoji.
IF(TODAY()>{your date field},"late","")
You can see if today is greater than the due and apply the emoji.
IF(TODAY()>{your date field},"late","")
Thank you! How would I also make it blank if there was no date in the due date column? I’m lost on all of the parenthesis and extra quotations and what they mean. I will have time to go research that one day, i hope…(but for now, i gotta make just this work).
Also, where do you get the emojis? (when on a Windows desktop).
Thank you! How would I also make it blank if there was no date in the due date column? I’m lost on all of the parenthesis and extra quotations and what they mean. I will have time to go research that one day, i hope…(but for now, i gotta make just this work).
Also, where do you get the emojis? (when on a Windows desktop).
Hi @Brandi_Mills,
You should be able to use something like this:
IF(
{Due Date},
IF(
OR(
IS_SAME(TODAY(), {Due Date}, 'day'),
IS_AFTER(TODAY(), {Due Date})
),
"💥"
)
)
This will first check for any value at all in the {Due Date} field – IF( {Due Date} ... . If the field is empty, then execution will stop and nothing will be output.
If any value at all is found in the {Due Date} field, then it will continue to process the next conditional. Inside that, we make an OR() condition. If either one (IS_SAME() or IS_AFTER()) comes back as true, then it will output the emoji, otherwise it will not output anything.
So the end result of this is either an 💥 emoji if the due date is today or past, or else a blank cell.
I prefer to use Airtable’s explicit Date functions like IS_SAME() and IS_AFTER() rather than comparing dates with math operators like < or >= because I feel it makes the formula more clear to future readers. That’s just personal preference, though.
Also, here’s an explanation of how to access the emoji picker in Windows:
How To Use Emojis On Windows 10 (Updated 2017)
Color emojis are supported natively on Windows. This is how to use the built-in emoji picker in Windows 10 Fall Creators Update which is new in 2017. Note: Windows 10 Fall Creators Update is due for release in the second half of 2017. Windows...
Hi @Brandi_Mills,
You should be able to use something like this:
IF(
{Due Date},
IF(
OR(
IS_SAME(TODAY(), {Due Date}, 'day'),
IS_AFTER(TODAY(), {Due Date})
),
"💥"
)
)
This will first check for any value at all in the {Due Date} field – IF( {Due Date} ... . If the field is empty, then execution will stop and nothing will be output.
If any value at all is found in the {Due Date} field, then it will continue to process the next conditional. Inside that, we make an OR() condition. If either one (IS_SAME() or IS_AFTER()) comes back as true, then it will output the emoji, otherwise it will not output anything.
So the end result of this is either an 💥 emoji if the due date is today or past, or else a blank cell.
I prefer to use Airtable’s explicit Date functions like IS_SAME() and IS_AFTER() rather than comparing dates with math operators like < or >= because I feel it makes the formula more clear to future readers. That’s just personal preference, though.
Also, here’s an explanation of how to access the emoji picker in Windows:
How To Use Emojis On Windows 10 (Updated 2017)
Color emojis are supported natively on Windows. This is how to use the built-in emoji picker in Windows 10 Fall Creators Update which is new in 2017. Note: Windows 10 Fall Creators Update is due for release in the second half of 2017. Windows...
Thank you very much -that worked!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.