Formula to add checkmark if post date is after today

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

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

Hmm…that didn’t work for me. :frowning:
I have this
image
which is resulting in this:
image

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 >=

1 Like

That worked! Thank you!!!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.