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

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.

Welcome to the community, @Rachel_Royal!

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

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