+2Hello,
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”
+27IF(
AND({Submitted to publication}, {Scheduled}),
"complete",
IF(
{Scheduled},
"needs to be submitted to publication",
"needs to be scheduled"
)
)
IF(
AND({Submitted to publication}, {Scheduled}),
"complete",
IF(
{Scheduled},
"needs to be submitted to publication",
"needs to be scheduled"
)
)
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?
+21Is 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?
Welcome to the community, @Tina_Lopez! :grinning_face_with_big_eyes:
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.