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.
Page 1 / 1
Welcome to the community, @Rachel_Royal!
You could create a formula field with a formula like this:
IF({Published Date}<TODAY(),"Published","Scheduled")
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.