Forum Discussion
Calculated column error
I created a SharePoint list with a Choice column for EDUCATION, IEP, and SCHOOL REPORTA. There are two choices for each of the three of the columns: Completed or Not Completer. I then created this f...
Rexter You're close! Try this:
=IF(AND(Education="Completed",IEP="Completed",[School Reports]="Completed"),"OK","Not OK")
Here's a great resource for SharePoint calculated columns.