How do I create a hyper care Line Graph for a dashboard


I need to create a specific line graph for a dashboard. This is what was requested but I am unsure how I need to structure my metrics sheet? X-axis = Dates, Y-axis = Number of stores. One line graph (in the case below, the Squared Milestones) would show the number of stores we planned to upgrade every day, and the other line graph (the Diamond) will show how many we actually upgraded (could be we didn’t have gear, tech didn’t show up, store manager was not there, etc). Lastly, the columns should represent the number stores where we had issues upgrading the site and went into hyper-care. (This graph will represent a large amount of store upgrades) Graph visual below.


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    There is currently no way to combine graph types within Smartsheet, but there is a bit of a workaround to have all of it in a single graph type. Feel free to reach out to me on LinkedIn if you would like to explore that a little bit more. It wouldn't be EXACTLY how you want it, but we can get pretty close. We just wouldn't be able to use the squares and diamonds (but can use different colors).

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!