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”


)


)


)


)