Hi guys,
I’m struggling to get this formula validated, which is odd as it’s been validated by an Excel master…?
IF(
{User status}=“New sign-up no story”,
“Send new sign-up email”,
IF(
{User status}="New sign-up story in new”,
“Send new story email”,
IF(
{User status}=“Sign-up no story”,
“Send sign-up no story email”,
IF(
{User status}="Sign-up Story in new”,
“Send new story email”,
IF(
{User status}=“Sign-up Story in draft”,
“Send story in draft email”,
IF(
{User status}="Sign-up story in published”,
“Send post-publication email”,
“Nothing”
)
)
)
)
)
)