Dashboard

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?


Thanks,

Bryan

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.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!