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 ...

SharePoint Online

Robin Nilsson
Sep 23, 2019
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:
https://techcommunity.microsoft.com/t5/SharePoint/Need-help-with-nested-IF-AND-statement-for-a-Calculated-Column/m-p/861306

Robin Nilsson

Bronze Contributor

Sep 23, 2019

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:

https://techcommunity.microsoft.com/t5/SharePoint/Need-help-with-nested-IF-AND-statement-for-a-Calculated-Column/m-p/861306

Rachel_Davis

Iron Contributor

Sep 23, 2019

Excellent idea! I never thought of using simple addition. I like it!

Forum Discussion

Calculated column from 7 Yes/No

Resources