Make a line graph of members over time

Options

I want a dashboard widget that shows the growth of our group over time. I have a master roster with everyone's names and columns for the date that they started and ended. How can I show the number of people we had each quarter in a line graph?

Answers

  • Ameya Athalye
    Ameya Athalye ✭✭✭✭✭
    Options

    @Sselby try this:

    1. Create a new sheet for your calculations
    2. Create Start Date and End Date columns and add those dates for each quarter.
    3. Then create rows for each quarter. In the next column add a formula that looks into your master roaster sheet and counts how many employees per quarter. It'd look something like this: =COUNTIFS({Master Roaster Start Date} >= [start date]@row, {master roaster End Date} <= [End Date]@row)
    4. Then you can pull that info into a report or dashboard (use graph widget and select line graph).


    The calculation sheet would look something like this:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!