Forum Discussion
Solved
Calculated column from 7 Yes/No
Hi everybody, I recently tried to use the calculated columns from SharePoint (first time trying) and I can't pull off what I need. Basically, I have 7 Yes/No controls and I simply want to create ...
Devildez_1994 Use the + operator to add up each column, and if the total is 7 then set your text. Here is a post I made last week where someone had the same issue:
Should just be a bunch of IF's. Like so.
=IF([Column1]=Yes,IF([Column2]=Yes,IF([Column3]=Yes,IF([Column4]=Yes,IF([Column5]=Yes,IF([Column6]=Yes,IF([Column7]=Yes, "OK")))))), "Not OK")
=IF([Column1]=Yes,IF([Column2]=Yes,IF([Column3]=Yes,IF([Column4]=Yes,IF([Column5]=Yes,IF([Column6]=Yes,IF([Column7]=Yes, "OK")))))), "Not OK")
ChrisWebbTechI tried it, does not seem to work. It's too bad SP does not show you where it comes from like in PowerApps^^