Formula to add checkmark if post date is after today

[Kelsey_Juszczak]

I have been messing around with formulas for two days, trying to figure out how to put a checkmark in the column if the post date is today or after. So, for my social media posts (which I don’t have automated from Airtable, I post them using another platform), once the time has come and gone that the post should have gone live, I want the formula column for that record to have a check box.

Thanks in advance for any help with this.
Kelsey

[Kamille_Parks]

IF(
{Date Field} >= TODAY(),
"✅"
)

[Kelsey_Juszczak]

Hmm…that didn’t work for me. :frowning:
I have this

which is resulting in this:

[Kamille_Parks · Accepted solution]

If you need to account for the time component then replace TODAY() with NOW(). If you want to show the checkmark next to dates that have already happened use <= instead of >=

[Kelsey_Juszczak]

That worked! Thank you!!!