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?