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
Best answer by Kamille_Parks11
Hmm…that didn’t work for me. :frowning:
I have this
which is resulting in this:
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 >=
+27IF(
{Date Field} >= TODAY(),
"✅"
)
IF(
{Date Field} >= TODAY(),
"✅"
)
Hmm…that didn’t work for me. :frowning:
I have this
which is resulting in this:
+27Hmm…that didn’t work for me. :frowning:
I have this
which is resulting in this:
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 >=
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!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.