Sep 20 2019 05:47 PM
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 a column that return a string like "Ok" if all seven are "Yes" and "Not Ok" if not. I can make it work with one but I tried every IF/AND coding that I knew and I always displays the same thing : every column displays "Not Ok"
Can someone enlighten me please :D ?
Sep 21 2019 08:21 PM
Sep 23 2019 01:23 AM
@Chris WebbI tried it, does not seem to work. It's too bad SP does not show you where it comes from like in PowerApps^^
Sep 23 2019 06:18 AM
I assume you've tried building this out one field at a time rather than all 7 at once, right? Do one, make sure that works. Add another. Make sure that works, etc.
Also, note that in SharePoint, while the Yes/No column reads text, the values stored are actually numbers. So when you do the calc, make sure you use numbers. I think Yes =1 and No = 0.
Sep 23 2019 07:16 AM - edited Sep 23 2019 07:18 AM
Solution@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:
Sep 23 2019 07:38 AM
Sep 23 2019 07:16 AM - edited Sep 23 2019 07:18 AM
Solution@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: