Creating dashboard chart using "Date Created" column?

Options

Hey everyone.

Here is what I'm hoping to do. I have a single smart sheet containing containing about 4 months worth of lines. I essentially want to create a bar graph showing the number in lines created by month. (So how many were entered in June, July, August, September). I have an automated date created column to show/record date of entry.

Is there a simple way to do this?

Answers

  • Christina09
    Christina09 ✭✭✭✭✭✭
    Options

    Happy Friday there,

    You can create a formula in sheet summary with the month June, July, August, September and create a graph via sheet summary.

    =COUNTIF(Created1:Created260, MONTH(@cell) = 7)

    =COUNTIF(Created1:Created260, MONTH(@cell) = 8)

    =COUNTIF(Created1:Created260, MONTH(@cell) = 8)

    =COUNTIF(Created1:Created260, MONTH(@cell) = 9)

    Note that When the MONTH() function contains a blank cell within the range of dates it is reviewing, it will produce the error displayed in the “Result” for this row. This is expected behavior. To resolve this, you’ll want to utilize an IFERROR() function.

    For more info, https://help.smartsheet.com/function/month?frame=0&nav=1


    If you continue to have a new entry, I would suggest having a helper column with this formula to extract the month and do a count if =MONTH(Created@row)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!