Formula for counting values from single-select drop down on a form

Paul Newcome

When you say it is not working... Are you getting an unexpected number or are you getting an error?

Saadia Ashraf

it shows 'Unparseable"

Paul Newcome

I see the problem... Your column name in your formula

[Third Choice (9-12 Months)]

is missing the colon in the column name.

[Third Choice (9-12 Months):]

That is the reason fort he error. Correct that and see if it is working for you.

Saadia Ashraf

Thank you, Paul. Let me correct this and update you.

Saadia Ashraf

Oh my god it worked!!!

Thank you so much :) :)

Now, my question is when a person is going to make the selections on the form- how this number will change? Where i will see those counts from the voting? In the same space? I already built out the form and now my only concern is how this will work?

Paul Newcome

The counts will automatically update as new forms are added.

Saadia Ashraf

Currently it shows a count of 3, so when a new form is added the count will change from 3 to 4 or reset back to let's say 1 when a selection is made? And, also, by default the count is going to be 3 so what if someone didnt vote for that particular slection it will still show 3-how can we put a tab and know this was selected and this wasnt.

Paul Newcome

Subtract 3 from the COUNTIFS formula.

=COUNTIFS(..............................) - 3

Saadia Ashraf

Thank you so much, Paul.

I truly appreciate your help. This was very very helpful.

The formula reset the count to 0 and now i am going to test the form and how the formula works.

Thank you for all your patience and co-operation throughout.

:)

Paul Newcome

Happy to help! 👍️

Saadia Ashraf

Hi @Paul Newcome So far the form is doing great. One tiny thing that when i submit the form, it throws the data selected by the user at the bottom of the sheet. is there a way i can add those results or selections from the form to go on the top rows? Like, have the new submissions added to the first row of the sheet instead of the bottom row?

Paul Newcome

There is a section in the Form Settings that allows you to have the form populate either the bottom or the top of the sheet.

Saadia Ashraf

@Paul Newcome Thank you so much for your help.

I was finally able to fix the changes.

Paul Newcome

Happy to help! 👍️

Saadia Ashraf

Hi @Paul Newcome just wanted to ask if only a licensed user is able to make edits in the smartsheet?