If statement help for blog

[Tina_Lopez]

Hello,

I need help with creating an if then that statement.

I want to create a formula where if a record is created then the status should change to “needs to be scheduled”, if the scheduled checkbox is selected then the status needs to change to “needs to be submitted to publication”, if both check boxes are filled then it will change the status to “complete”

[Kamille_Parks]

IF(
   AND({Submitted to publication}, {Scheduled}),
   "complete",
   IF(
      {Scheduled},
      "needs to be submitted to publication",
      "needs to be scheduled"
   )
)

[Tina_Lopez]

Thank you so much! It worked and helped so much!

[Tina_Lopez]

Is there an option where if checkbox is filled then can it create a prompt?

For example, when the user clicks the publication box and it’s completed, I want them to get sent an action to distribute that link to certain social media outlets?

[Justin_Barrett]

Welcome to the community, @Tina_Lopez! :grinning_face_with_big_eyes:

Tina_Lopez:

For example, when the user clicks the publication box and it’s completed, I want them to get sent an action to distribute that link to certain social media outlets?

That depends on what you mean by “sent an action.” If you meant “sent an email”, you could use an automation triggered by the change in a checkbox field, which could send an email to the user reminding them to share the link.

Lots of other options are possible with automations as well. If you haven’t looked into the automation system yet, here’s an overview:

Airtable Support

Automations overview

Watch a training! Power up your workflow   IN THIS ARTICLE OverviewTriggersActionsSetup tipsCurrent limits   Overview Automations allow you to configure custom trigger-action workflows direct...