Sheet Summary

Options

I have a Requested Ship Date and I want to track the Month and Year that they were requested in a sheet summary. At some point I want to take that summary and put in on a Dashboard in a graph to show upper management the progress. is this possible?

This is just a few month of the work I have an entire year that I would like to summarize.

Thank you

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓
    Options

    Ah. Ok. In that case you will in fact need either multiple sheet summary fields or (preferred) a second sheet. In the second sheet you would enter your labels in one column then in another column you could use a formula such as this:

    =COUNTIFS({Date Column}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2022))


    The above would give you the counts for January 2022. Adjusting the 1 for the month and the 2022 for the year in the formula will give you the counts for each month.


    You would then reference this table to create your graph on the dashboard.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!