Create a dashboard to display a count of multiple cell entries
I am struggling (absolutely newbie) to create a dashboard that will count all the individual certifications, and all the professional certifications and all the in progress certifications - attached is a screenshot - can anyone help?
Best Answer
-
Paul Newcome ✭✭✭✭✭✭
You don't HAVE to, but I generally create a dedicated metrics sheet mainly because I have a lot of separate calculations I want to run and display (typically).
Answers
-
Paul Newcome ✭✭✭✭✭✭
Are you able to provide more details? Are you wanting counts by person, or just totals for the entire sheet?
-
GRoberts ✭
Hi Paul, apologies for the slow response and thanks for engaging - I would like a count for the full sheet, but in 3 charts - 1st being Certifications, 2nd being Professional Certifications and the 3rd being In Progress
-
Paul Newcome ✭✭✭✭✭✭
In that case you will want a COUNTM function.
=COUNTM([Column Name]:[Column Name])
-
GRoberts ✭
Thanks Paul, do I need to create this on another sheet to make the dashboards?
-
Paul Newcome ✭✭✭✭✭✭
You don't HAVE to, but I generally create a dedicated metrics sheet mainly because I have a lot of separate calculations I want to run and display (typically).
-
GRoberts ✭
Thanks Paul - that did everything I needed!
-
Paul Newcome ✭✭✭✭✭✭
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/106815/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/106815/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>