Graphs and Charts

Anne-Solene Monrouzeau

Hi,

I am fairly new with Graphs and Charts in Smartsheet. I am trying to create a monthly operating report with different graphs. An example is a KPI trend month by month. I am stuck at the first step: I have the raw data by day. I pulled them in a report and don't know how to average by month to create the graph by month.

Any idea?

Thanks,

Anne-Solene

Kelly Moore

Hey @Anne-Solene Monrouzeau

One approach would be to add a Text/Number helper column [Month Number] to your data sheet so you could then group by Month Numbers in reports or use in other formulas

In the helper column, add this formula

=IFERROR(MONTH([your date column]@row),0)

The IFERROR is there to prevent algebraic formulas (like average) from having errors if the MONTH function had an error.

If you need further help, come back and let us know what step you're on. The community is always happy to help.

Cheers