Sign in to join the conversation:
I'm trying to create a chart that counts the number of entries in a particular column. eg a column which lists employee names. How do i produce a chart which tells me how many rows that name appears in?
Thanks in advance for any tips
You would need to create a table somewhere that has all of the names listed.
NAME COUNT
John Doe f
Jane Smith f
Eric Clapton f
Donald Duck f
Betty White f
.
Where you see "f", you would use a formula similar to this...
=COUNTIFS([Original Name Column]:[Original Name Column], Name@row)
This will give you the count for each name. You would then build your chart off of this table.
Hello all, I have a weekly report that I'm building and would like to be able to only expose two weeks worth of status. The report has a status and a commit date column and I'd like to remove anything that is "Done" and more than 2 weeks old. I'm trying to avoid having a report that has 100 rows of tasks that have been…
Is there a way to save as a backup all sheets and workspaces? I am able to create a backup for all of the files shared with me. As the account's admin, can I back up all of the sheets and workspaces by all of our licensed users - even if they are not shared with me. We recently had a licensed use delete sheets and…
When I print my dashboard, the color coding next to the divisions disappear. Any clue to a fix?
