Smartsheet Tutorial: How to Build Metrics & Charts from Multiselect Columns

[@joycechen2394]

Thank you! I have a quick question for empty values, is that possible to exclude those category fields in bar chart if there is 0 value?

[@Gapcreations]

Thanks for the detailed video and appreciated your efforts. I have scenario- I have 10 different sheets with individual data and same structured fields. Consolidated all the details with reports and how do I create a metrics? Currently cannot reference the report for metric calculations. Is there any suggestion?

[@echolocity]

Hi @ganeshap23 - Glad to hear you liked the video. We have another video on metrics that may help you further:
th-cam.com/video/-A6dzcbD3LA/w-d-xo.html

[@Gapcreations]

@@echolocity thanks for sharing the video..this would be a great help

[@Alain0Guridy]

Wow thanks a lot, you save my life

[@echolocity]

Awesome - glad you've found this video helpful!

[@MegaMamaMeg]

How did you setup your original sheet for the metrics?

[@echolocity]

We start from the "Grid" Sheet type vs a project or task list which have pre-configured column types (like dates, drop downs, etc).

[@jeffhendricks3341]

Hello, Do I have anyway to do a waterfall chart in smartsheet? thank you

[@echolocity]

Hi Jeff - Smartsheet does not currently offer a Waterfall chart as an option in the Chart Widgets. Here's a helpful community post that provides a possible work around as well as a link to to an article: community.smartsheet.com/discussion/87749/waterfall-chart

[@nefertitiraseti94]

Thank you

[@echolocity]

You're welcome! You can Subscribe to help our channel grow and also get notified of new Smartsheet videos! : th-cam.com/video/hAJ_cB7VcCw/w-d-xo.html