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.
Feb 13, 2022 06:16 AM
Hi, I’m trying to create an automation to update the status of a record from “scheduled” to “published” when the published date has passed. Does this need to be done using a formula? I can’t find a way to do it with “when a record matches conditions.” I’m scheduling posts on Hootsuite manually, so the only thing I want AirTable to do is change the status when the date has passed.
Feb 13, 2022 06:30 AM
Welcome to the community, @Rachel_Royal!
You could create a formula field with a formula like this:
IF({Published Date}<TODAY(),"Published","Scheduled")