Creating dashboard chart using "Date Created" column?

Dan Tanner
Dan Tanner โœญโœญโœญโœญโœญ

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 Community Champion

    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!