Various errors when rolling out dashboard updates

Paigebrim ✭✭
edited 07/12/22 in Smartsheet Basics

Hello- we are trying to update all of our dashboards and are receiving the following errors:

Chart widget 'Number of Tasks': Multiple Rows found with Primary column value '2022-12'.

Chart widget 'Number of Tasks': Cannot remap selection range.

Chart widget 'Number of Task Hours': Multiple rows found with Primary column value '2022-12'.

Chart widget 'Number of Task Hours; : Cannot remap selection range.

Gridgantt widget 'Phase Gate Advancement Criteria': Cannot remap interaction hyperlink.

Metric widget error: Dashboard level must be at least 4, found 3 (1284).



  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭

    Hi @Paigebrim

    I've recently experienced similar errrors. Although the cause and solution could be many things, I found that moving all the metrics to the 1st (2) columns on the metric sheet was the solution to some. This is not a perfect solution because you have to manually move the metrics on all the existing projects. Also, the color options potentially change when not running the data across columns. Maybe try it on 1 sheet and run the test global update on that to see how it goes.

    I hope this helps.


    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner