- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 26, 2024 02:19 PM
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.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 26, 2024 02:54 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 26, 2024 02:54 PM
In your rollup field use the were clause to say where question1 = yes, etc.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 26, 2024 03:25 PM
Hi @Dan_Montoya when I do this, I am getting '0'. Should I be using COUNTA?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 26, 2024 06:08 PM - edited ‎Feb 26, 2024 06:09 PM
Yeah, using COUNTA would make that rollup field work like you want. You could also try using a Count field as well:
