Basic Chart

Neil Brady
Neil Brady ✭✭
edited 12/09/19 in Smartsheet Basics

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


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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.