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

955 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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")