If, and, or statements
I'm new to Smartsheets and struggling to update my Overall Status depending on the status of Financials, EHS and Tech Qual
If all three are Approved or N/A then Overall Status = Approved
If at least 1 is In Progress or blank then Overall Status = In Progress
If at least 1 is Not Approved then the Overall Status = Not Approved
Thanks for your help
Help Article Resources
Check out the Formula Handbook template!