Need some help as I want to see if I am going in the right direction as it looks like the an IF formula I am working on is going to be about 50 lines long.
In essance it is and expansion of the below formula to see which approval level is still needed. The below formula just tells me if it is approved or not but I would like this to call on when it is not approved and then multiple varients to call out the level it needs an approval. With all possiable combinations this is going to be very long. I have to use contain as the approval field is time date stamped so it records all changes. Any help appreciated.
If(
[Option] = "Lapse/Expire", "Not Required",
[Fixed Pricing] = false and [Approval Level] = "-" and [Option] <> "" ,"TAM Approval Level",
[Fixed Pricing] = false and [Approval Level] = "DSM" and Contains([DSM Approval], "Approve") , "Fully Approved",
[Fixed Pricing] = false and [Approval Level] = "Sales Director" and Contains([DSM Approval], "Approve") and Contains([Sales Director Approval], "Approve"), "Fully Approved",
[Fixed Pricing] = false and [Approval Level] = "GM" and Contains([DSM Approval], "Approve") and Contains([Sales Director Approval], "Approve") and Contains([GM Approval],"Approve"), "Fully Approved",
[Fixed Pricing] = false and [Approval Level] = "CCO" and Contains([DSM Approval], "Approve") and Contains([Sales Director Approval], "Approve") and Contains([GM Approval],"Approve") and Contains([CCO Approval], "Approve"), "Fully Approved",
[Fixed Pricing] = true and [Approval Level] = "-" and [Option] <> "" ,"TAM Approval Level",
[Fixed Pricing] = true and [Approval Level] = "DSM" and Contains([DSM Approval], "Approve") and Contains([Global Sales Operations Approval], "Approve"), "Fully Approved",
[Fixed Pricing] = true and [Approval Level] = "Sales Director" and Contains([DSM Approval], "Approve") and Contains([Sales Director Approval], "Approve") and Contains([Global Sales Operations Approval], "Approve"), "Fully Approved",
[Fixed Pricing] = true and [Approval Level] = "GM" and Contains([DSM Approval], "Approve") and Contains([Sales Director Approval], "Approve") and Contains([GM Approval],"Approve") and Contains([Global Sales Operations Approval], "Approve"), "Fully Approved",
[Fixed Pricing] = true and [Approval Level] = "CCO" and Contains([DSM Approval], "Approve") and Contains([Sales Director Approval], "Approve") and Contains([GM Approval],"Approve") and Contains([CCO Approval], "Approve") and Contains([Global Sales Operations Approval], "Approve"), "Fully Approved",
[Option] = "", "Not Submitted",
"Approval Needed")