checked box formula to use for dashboard?

Options

I'm trying to create chart that will show cleared vs uncleared roles.

I am trying to apply a countif formula for my sheet but it's not showing the counts. I am using the formula below. Am I doing something wrong

Please help!

Thanks,

Nyasha

Tags:

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 12/14/20 Answer ✓
    Options

    Hi @Nyasha Samaneka

    sorry for the delay, please find in the following the solution,

    1- I created two sheets first one is the "Master Readiness Roster" sheet which contains your database and selection the following is a screenshot.

    2- The second sheet is the summary sheet which we will use it to count the number of cleared & uncleared counting the following is a screenshot.


    Now the formula you will use is:

    A- to count Cleared number ( Checked ) =COUNTIFS({Master Readiness Roster Range 1}, Master@row, {Master Readiness Roster Range 2}, true). and convert it to column formula.

    B- to count Uncleared number ( Unchecked ) =COUNTIFS({Master Readiness Roster Range 1}, Master@row, {Master Readiness Roster Range 2}, false)

    C- To Count the total number ( Checked & Unchecked ) =COUNTM({Master Readiness Roster Range 1})

    3- then you can create a chart in your Dashboard using the summary sheet table


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Answers

  • Nyasha Samaneka
    Options

    Here is the the formula im using for the cleared (checked boxes): =COUNTIFS({Master Readiness Roster Range 3}, @cell = [Primary Column]@row, {Master Readiness Roster Range 1}, @cell = ("(Checkbox Onboarding & Payroll Cleared by SS), =true"))

    is this one for the uncleared (unchecked): =COUNTIFS({Master Readiness Roster Range 3}, @cell = [Primary Column]@row, {Master Readiness Roster Range 1}, @cell = ("(Checkbox Onboarding & Payroll Cleared by SS), =false"))

    its not showing an error but all I get is zero

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    Hi @Nyasha Samaneka

    Hope you are fine, could you please supply a screenshot for your sheet to showing the column name you are using in your formula ( please remove any sensitive date )

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Nyasha Samaneka
    Options

    Hi @Bassam.M Khalil

    Im from these column which is from a separate sheet

    This is what I have been trying, but keeps coming up 0

    I hope that's clear thanks

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    Hi @Nyasha Samaneka

    Ok i will prepare for you a sample sheet to make the solution clear for you

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 12/14/20 Answer ✓
    Options

    Hi @Nyasha Samaneka

    sorry for the delay, please find in the following the solution,

    1- I created two sheets first one is the "Master Readiness Roster" sheet which contains your database and selection the following is a screenshot.

    2- The second sheet is the summary sheet which we will use it to count the number of cleared & uncleared counting the following is a screenshot.


    Now the formula you will use is:

    A- to count Cleared number ( Checked ) =COUNTIFS({Master Readiness Roster Range 1}, Master@row, {Master Readiness Roster Range 2}, true). and convert it to column formula.

    B- to count Uncleared number ( Unchecked ) =COUNTIFS({Master Readiness Roster Range 1}, Master@row, {Master Readiness Roster Range 2}, false)

    C- To Count the total number ( Checked & Unchecked ) =COUNTM({Master Readiness Roster Range 1})

    3- then you can create a chart in your Dashboard using the summary sheet table


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Nyasha Samaneka
    Options

    Thanks @Bassam.M Khalil its worked out perfectly. Much appreciated

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    You are welcome anytime @Nyasha Samaneka 

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!