Help on formula

VioletB

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

 

Andrée Starå

Hi Violet,

Try something like this.

I'd recommend using Parent/Children and the children would be the answer​​​​​​​s. 

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