Dashboard colored panels

I would like to know how to create these colored panels as shown in the Sales Pipeline and Forecast dashboard example on https://www.smartsheet.com/all-about-sales-pipeline-management. I have tried using rich text and title text and metrics and none of them seem to allow for the entire background to be set to a color as shown in this example. Would appreciate any assistance with this.

dashboards-gallery-sales-pipeline@2x.png

Find more posts tagged with

Project Management

Comments

Paul Newcome

If you use a metrics widget and the background color of the cell itself is another color, it will fill almost to the border. You would then set the dashboard color to white to hide that border.

Chak Khiam

To turn background to white, click "Settings" (button to the left of "Share") when the Dashboard (make sure) is in Edit mode.

Default is Gray, Check "White" in the dialog box.

Phil Wightman

Hi Paul,

Can you explain in more detail your response please.

I have followed what you suggested but the widget title when coloured is noticeably wider that the cell when coloured. Also, I cent see how to shade the text in the cell below the number. See below.

Thanks

Phil

Paul Newcome

Can you try to repost your screenshot please?

Phil Wightman

Hi Paul,

I cant even get the body of the widget to colour now! So frustrating

Rgs

Phil

Jenna Bailey

I am going to re-hash this as it doesn't seem to be solved.

Is this just not an option any longer?

Taylor Trail

Hi this is still an option. To get the colored background you must go to the cell where the metric is pulling from and there you can change the background color/text color of the cell.

When you go to your dashboard, click on the metric and click "Use cell formatting".

Erica Hodgdon

Does anyone know how to create the progress bars shown in the upper right hand corner of the dashboard above? Ex. "15 out of 50 sold" with the progress bar and the "-" symbol?

Thank you!

Andrée Starå

Hi @Taylor Trail

Yes, it is. Did you get it working?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Erica Hodgdon

You'd use a so-called Master Metric Sheet to collect all the metrics by using cross-sheet formulas and calculate the values to show, but depending on the needs in general, you could also add them to the specific sheet.

Make sense?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…