Skip to main content

Hello:

I am trying to create a RollUp for A Scoring Process we are undergoing related to our Strategic Plan. 

I have managed to get everything else to work; however, I am running into a challenge doing a RollUp for two questions.

One is a Simple Yes/No Question. I want to get the total number of Yes/No Votes.

The second is a Yes/No/Maybe question. Likewise, I would like to get the total number of Yes/No/Maybe votes.

I have tried creating conditional formatting that counts IF FIELD=YES, but that is not giving me the total number of 'Yes' when I roll up. I recognize I will probably need five new columns - but I cannot figure out how to get them to populate with the required information.

Thanks for any help. 

In your rollup field use the were clause to say where question1 = yes, etc.

In your rollup field use the were clause to say where question1 = yes, etc.


Hi @Dan_Montoya when I do this, I am getting '0'. Should I be using COUNTA?

Hi @Dan_Montoya when I do this, I am getting '0'. Should I be using COUNTA?


Yeah, using COUNTA would make that rollup field work like you want.  You could also try using a Count field as well:

Reply


Terms & Conditions