Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Counting Yes/No in Roll-Up

Topic Labels: Base design Data
Solved
Jump to Solution
1044 3
cancel
Showing results for 
Search instead for 
Did you mean: 
sundevil282
5 - Automation Enthusiast
5 - Automation Enthusiast

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. 

1 Solution

Accepted Solutions
Dan_Montoya
Community Manager
Community Manager

In your rollup field use the were clause to say where question1 = yes, etc.Screenshot 2024-02-26 at 2.54.28 PM.png

See Solution in Thread

3 Replies 3
Dan_Montoya
Community Manager
Community Manager

In your rollup field use the were clause to say where question1 = yes, etc.Screenshot 2024-02-26 at 2.54.28 PM.png

sundevil282
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

Screenshot 2024-02-27 at 10.08.12 AM.png

Screenshot 2024-02-27 at 10.08.15 AM.png