Sharepoint Online List: Column Formulas: Counting Yes/No answers in a numeric column

James Purcell 21 Reputation points
2021-02-03T14:13:34.72+00:00

Hi

I have four columns of the Yes/No type, I would like to create a 5th column that counts the number of yes. I have seen other answers but I can not make the code work, I keep getting a syntax error. I added the column names with the picker, I have set the output to number. I tried code with =true in the test part of the formula. Can anybody help please? I believe that I can treat the Yes/No columns as boolean.

IF([Finanzielle Sanktionen],1,0)+IF([Geschätzter Gesamtwert 'Velocity'/Aufwand],1,0)+IF([Gibt es eine bestimmte vertragliche Go Live Ziele],1,0)+IF([Nicht standardmäßige Anforderungen],1,0)

Regards

James

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,823 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,576 questions
0 comments No comments
{count} votes

Accepted answer
  1. Echo Du_MSFT 17,116 Reputation points
    2021-02-04T03:01:29.797+00:00

    Hello @James Purcell ,

    Please following steps:

    1) Create a Calculated field named "Count"

    2) Use the following Formula:

    =IF([Y/N],1,0)+IF([T/F],1,0)+IF([T or F],1,0)+IF([Y or N],1,0)  
    

    3) Select Number as the data type returned from this formula

    4) OK button

    63756-6.png

    63809-7.png

    Thanks,
    Echo Du

    ===============
    Updated Answer ==============

    Hi @James Purcell ,

    I run the test again, and this time I will follow your naming requirements to name these columns.

    64303-1.png

    64266-2.png

    Create a Calculated column named Count. The formula is as follows:

    =IF([Finanzielle Sanktionen],1,0)+IF([Geschätzter Gesamtwert 'Velocity'/Aufwand],1,0)+IF([Gibt es eine bestimmte vertragliche Go Live Ziele],1,0)+IF([Nicht standardmäßige Anforderungen],1,0)   
    

    64323-3.png

    I suggest that you judge in turn according to the order in which the columns are created.

    64324-4.png

    Thanks,
    Echo Du

    ==============

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. James Purcell 21 Reputation points
    2021-02-04T16:08:37.57+00:00

    Hi

    Thank you for your detailed reply, I believe I have followed your guide step by step, but I am still receiving a syntax error.

    64112-sorry.png

    I have entered the following data, I thought I would test to see if I could get it working with just one column first:

    64121-create-column.png

    The column layout is as follows

    64067-columns.png

    And the column settings are:

    64030-settings.png

    I did change the setting to allow management of all content types so that I could change the title column from being required, but I changed that back afterwards.

    Thank you again for your time and help.


  2. Gerardo Lewis 0 Reputation points
    2023-08-29T20:58:19.32+00:00

    how di you resolved it doesent work for me ?

    0 comments No comments