Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula to add checkmark if post date is after today

Topic Labels: Formulas
Solved
Jump to Solution
342 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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

See Solution in Thread

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

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

That worked! Thank you!!!