Multiple if statements combined into 1
I am trying to create a formula to update the status column.
If ALL 5 people columns has any combination of "approved", "approved: with questions", "approved: with comments", then it marks the status Approved.
If any of the 5 people columns has "In Review" or Reviewed: with questions", the status column in mark as "In Review".
I am not sure how to build this the most efficient way.
Help Article Resources
Check out the Formula Handbook template!