How to compare multiple column values and set the final value in Calculated field

I have four SharePoint choice fields. I created a new calculated field and I want to know the formula of how I can compare the values from the four choice fields and set the calculated value

For Instance, if column1="Complete" and column2 = "Complete" and Column3 = "Complete" and Column4 = "Complete" then set the calculated field value as "Submitted" otherwise "Not Submitted"
Who is Participating?
PstryConnect With a Mentor Commented:
The formula is:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.