Hello everyone,

I am trying to make my first Dashboard. On my data sheet, I have dates from Jan 1 2021-March 31 20201. Instead of showing all individual days, How can I make it only show month like January, February, and March to summarize data monthly?



Best Answer

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

    Does the {Date} range contain actual date values in a date type column?

    If not, try correcting that first. If so or if you still continue to get that particular error, try this little tweak...

    =COUNTIFS({Date}, IFERROR(MONTH(@cell), 0) = MonthNo@row, {Indicator}, 1)

    The IFERROR will account for blanks and non-date values within the date range so that the COUNTIFS can function properly.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!