1

I have a list built with three levels of approval on an item. I want to add a calculated column to quickly show the status of the item based on those approvals.

So if all three approvals exist, the calculated column would show "Complete". If all/any of the three approvals are missing, the column would show "In Progress".

The columns it is calculating off of are choice columns. Any tips?

Improve this question
1
  • Do you have 3 different choice columns for 3 levels of approval status?
    – Ganesh Sanap
    Mar 10 at 2:41

1 Answer 1

Reset to default
0

Try using formula in this format:

=IF(AND([1st Level Approval] = "Approved", [2nd Level Approval] = "Approved", [3rd Level Approval] = "Approved"), "Complete", "In Progress")

Use approval column names and their approval status values for all three level approvals as per your SharePoint site/list configurations.

Note:

  1. Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,). For example: If you are using German language for your SharePoint site
  2. Use correct display names of your columns in the formula

Official Documentations:

  1. Calculated Field Formulas
Improve this answer
3
  • 1
    Perfect! Thank you very much.
    – MaggieK
    Mar 10 at 17:44
  • You're welcome. Glad it worked for you.
    – Ganesh Sanap
    Mar 10 at 18:53
  • Please accept it as an answer as it helped you and it will help others with similar question to find the correct answer easily
    – Ganesh Sanap
    Mar 10 at 18:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.