checked box formula to use for dashboard?

Nyasha Samaneka

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

Bassam Khalil

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

Nyasha Samaneka

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

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 )

Nyasha Samaneka

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

Hi @Nyasha Samaneka

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

Bassam Khalil

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

Nyasha Samaneka

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

Bassam Khalil

You are welcome anytime @Nyasha Samaneka