Hi everyone,
I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown below)
Now I want to add on to this formula so, if the column {Out For Approval} is checked, I want the status to change from "In Prepress" to "Out For Approval".
Status Column:
=IF([Proof Approval - Kim]@row = "approved", "proof approved", IF([Proof Approval - Kim]@row = "not approved", "pending", IF([Plate Number]@row = "", "Pending", "In Prepress")))
Can anyone help (screenshot also attached)?
