Help on formula

Hi I am fairly new to Smartsheet (3 whole days)

2 questions.

I have a dropdown box titled 'Finding Rating' with 3 values: Conformance, Minor Conformance and Major Conformance.

1.Needed a count of each type (so i can create a graphs, on dashboard), I created another 3 columns titled Conformance, Minor Conformance and Major Conformance.and then copy/pasted respective findings ie conformance to conformance table. I used =COUNTIF(Conformance3:Conformance92, "Conformance")

Is there another way to create a count? Can I create a count on the dropdown fox column?

2. Instead of doing a copy/paste to each cell, is there a formula that can pickup from my dropdown box and add to respective 3 new columns? have tried several functions but they all come back with an error.

thank you

Violet

Find more posts tagged with

Formulas

Conditional Formatting

Comments

Andrée Starå

Hi Violet,

Try something like this.

I'd recommend using Parent/Children and the children would be the answers.

Add three rows in the drop-down column and add the formula below. Update the "Conformance" to the other values as needed.

Finding Rating 4 is the Parent Cell.

=COUNTIF(CHILDREN([Finding Rating]4); "Conformance")

The same version but with the below changes for your and others convenience.

=COUNTIF(CHILDREN([Finding Rating]4), "Conformance")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

VioletB

Hi,

Did a copy and paste in the cell, but the result came back as 0 (zero).

anything else I can try?

Andrée Starå

Ok.

Can you maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Best,

Andrée

Andrée Starå

Thanks!

I'll get back to you soon!

Andrée Starå

Glad we got it working!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Help With If Count If to Identify Unique Values in a Column
I'm trying to make a helper column to identify if a new/unique project code has been entered in a column so that I know when a new project has been created. I've been trying to set up this formula and plan to then set up an automation to be notified when "New Project Code" has been entered into a cell. It seems to be ok on…
Logging separate data points of the same type of data for one row
Looking for a way to easily log and reference multiple data points for the same type of data (ex: successful phone contacts) that all show for one entry (by member name). Want this to be both easy to enter the information (ideally by interacting with the same row via Dynamic View), and easy to see data on the back end of…
Why does the parent task my % column show as a decimal value instead of a percentage?
Why does the parent task my % column show as a decimal value instead of a percentage? I checked the column and project settings, and they are identical to another smartsheet in which the values show up as a percentage.