Formula Question

Options

Hi

I have the formula below that indicate the close, denied, cancel and open status which is currently working

=IF([GSP Status]@row = "Cancel", "CANCEL", IF([GSP Status]@row = "Denied", "DENIED", IF(NOT(ISBLANK([Final Settlement PO ($USD)]@row)), "CLOSED", IF([Final Settlement PO ($USD)]@row = "", "OPEN"))))

Right now if I want to change the formula as scenario below

Status: GSP status=Cancel, Status=Cancel

Status:GSP status=Denied, Status=Denied

Final settlement PO is not blank=Closed

If "Current Queue" = "Claim Approved" or "Claim & Reserves Approved" & Final Settlement PO ($USD) is blank, then mark as "Open - Approved"

If "Current Queue" is not "Claim Approved" or "Claim & Reserves Approved" & Final Settlement PO ($USD) is blank, then mark as "Open - WIP"

Anyone can advise how I can twit formula to follow the scenario above. Thanks

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!