USING MULTIPLE IF STATEMENTS

Question

Hi I have a complex calculated column.

It looks across 10 columns, what I want it to do is look at each column and see if all columns have the value of "Complete" or "N/A" in the column, the calculated column equals "Complete" otherwise "Not Complete"

Answer 1

Hi @Kelly Mayes,

Thank you for posting in this community.

Please try this calculated formular. Don't forget to replace your column names:

=IF((IF(OR([Column1]="Complete",[Column1]="N/A"),1,0)+IF(OR([Column2]="Complete",[Column2]="N/A"),1,0)+IF(OR([Column3]="Complete",[Column3]="N/A"),1,0)+IF(OR([Column4]="Complete",[Column4]="N/A"),1,0)+IF(OR([Column5]="Complete",[Column5]="N/A"),1,0)+IF(OR([Column6]="Complete",[Column6]="N/A"),1,0)+IF(OR([Column7]="Complete",[Column8]="N/A"),1,0)+IF(OR([Column8]="Complete",[Column1]="N/A"),1,0)+IF(OR([Column9]="Complete",[Column9]="N/A"),1,0)+IF(OR([Column10]="Complete",[Column10]="N/A"),1,0))=10,"Complete","Not Complete")

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.