Project Cost Tracking Template

Lisa H.
Lisa H.
edited 09/04/24 in Smartsheet Basics

I found a template for the above that included a bar graph up top. I tried importing it,but lost the bar graph in the process. How do I fix this? Thx!

Answers

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭

    If there's no values behind a graph, it may just say "No data to display" until you start filling in values. Is the total widget gone? If the widget itself is gone, it should be easy enough to recreate, as long as you know where the source was coming from, with the Chart widget:

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner

  • Appreciate your feedback….

    I did find out that visual components are lost when importing a template. I would have to manually recreate. I then thought I could just use the formula the sheet had listed on the template to recreate in Smartsheet. However, the template graph used the SERIES function, which apparently is not available in Smartsheet. Like you mentioned, I will need to try to recreate this from a dashboard widget.

    So here is crossing fingers & toes that works for me 😀