I’m creating a big if statement to track where I am in creating an email. I can get the email status to flip from “ready to send” to “live” if the send date has passed, but I can’t get my status field to flip to “Live” on the same date if the hours option is turned on. I use the hours to also put in my send time, so turning it off isn’t really an option.
Any work-around for this?
This is my working code, without IS_SAME in it. I’m open to suggestions on simplifying the code, too:
IF(
IS_BEFORE( {Send Date}, TODAY()
), “Live”,
IF(
AND(
{Test Sent},Checklist,{Requestor/Manager Approval}
), “Ready to Send”,
IF(
AND(
{Test Sent},{Requestor/Manager Approval}
), “Approved”,
IF(
{Test Sent} = 1, “Waiting for Apprtoal”, “Not Started”
)
)
)
)
