Progress charts

Sayyad Ahmad Basha

Hi, Can some one help me how to build a progress chart using smart sheet? Similar to the one shown below

Once level is fine instead of shown 3 levels, would like to show particular day GREEN/RED based on ‘pending requests’ shown in the attached table

Smart Sheet query_progressive reports.xlsx

Any help will be much appreciated

Thanks,

Basha

Genevieve P.

Hi @Sayyad Ahmad Basha

There are no Smartsheet charts that look the same as the one you have above. You could potentially create a Donut Chart, but it would group your data together to display the number of Green versus the number of Red, without identifying each specific day.

If you want to show the Day and the Colour, I would suggest applying Conditional Formatting to the cells in the sheet to colour your rows. Then you can create a Report and Sort it by the Date to show the progress. You can embed a Report into a Dashboard with the Report Widget. Would that work for you?

See this Webinar for more information on Dashboards: SmartStart: Dashboards

Cheers,

Genevieve

Genevieve P.

Hi @Sayyad Ahmad Basha

There are no Smartsheet charts that look the same as the one you have above. You could potentially create a Donut Chart, but it would group your data together to display the number of Green versus the number of Red, without identifying each specific day.

If you want to show the Day and the Colour, I would suggest applying Conditional Formatting to the cells in the sheet to colour your rows. Then you can create a Report and Sort it by the Date to show the progress. You can embed a Report into a Dashboard with the Report Widget. Would that work for you?

See this Webinar for more information on Dashboards: SmartStart: Dashboards

Cheers,

Genevieve

Sayyad Ahmad Basha

Hi Genevieve, your suggested solution is not exact but closure to my requirement

Thank you,

Basha