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:
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...
