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.

Need to update status in content calendar when published date has passed

Topic Labels: Automations
342 1
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

Welcome to the community, @Rachel_Royal!

You could create a formula field with a formula like this:

IF({Published Date}<TODAY(),"Published","Scheduled")