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.
I'd like to create an automation that does two things. Trigger: When rows are added or changed I want the following two items to happen. Record a date in the column "Completed". Set to today. Move row to sheet called "Completed Jobs" Please let me know if there is a way to do this using conditions?? If so, please give me…
a PM asked me to look at his schedule because one of his predecessor cells had #REF. We can't figure out why this is happening because he references line 176 in other cells in the column. When I went and looked at the schedule on my computer, the #REF error moved to a totally different cell and I don't see it in the same…
Still looking for documentation, but I am curious about the limitations with the dropdown linking in Table View. Does a person need to have access to the dropdown source sheet in order for the dropdowns to populate on the Table sheet?
