SharePoint using 4 individual IF formulas on one column.

Question

I have 4 columns each with a Yes/No value in it. What I want to do is have another column as a progress bar. Each column answered as Yes (True) will be worth 25% or just the number 25. If all 4 are True then the Progress bar value will be 100%.

In the progress bar column I am trying to use this Formula:

=IF([Application Form Completed?]="Yes",+25)

=IF([Application Form Sent?]="Yes",+25)

=IF([T's & C's Signed?]="Yes",+25)

=IF([References Checked?]="Yes",+25)

*Data returned as Number and shown and a percentage.

The issue is that each row is now displaying 100%, which isn't true.

I tried a combination of =IF(AND(IF(AND))... statements but that also proved to not work.

Answer 1

Hi @Sergei Drew ,

I achieved your requirement by creating calculated column (the result of implementation is below).

Here are steps:

1.I created a calculated column named progress bar using the following formula（ Show as percentage）:

=(IF([Application Form Completed?]=TRUE,1,0)+IF([Application Form Sent?]=TRUE,1,0)+IF([T's & C's Signed?]=TRUE,1,0)+IF([References Checked?]=TRUE,1,0))/4

---

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.