Help on formula

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

 

Smartsheet.JPG

Comments

  • Andrée Starå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

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • 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åAndrée Starå ✭✭✭✭✭
    edited 06/24/19

    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, [email protected])

    Best,

    Andrée

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Thanks!

    I'll get back to you soon!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Glad we got it working!

    Best,

    Andrée

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.