Updating Grant colors based on status in report and dashbords

Surya

Surya ✭✭✭

04/02/24 in Smartsheet Basics

Can we update the colors in grant view based on status values? All our reports , grant views should show the following. Appreciate any help.

Status Value - Color

In Progress - Green

Completed - Blue

Not Started - Gray

0 ·

Answers

Carson Penticuff Community Champion

04/02/24

The "task bar" setting in conditional formatting will modify the "gantt bar" color.

1 · Share on Facebook Share on Twitter
Surya ✭✭✭

04/03/24

Yes. Thank you.

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Copy rows
Hi, I am trying to use an automation workflow where I copy a row from one sheet onto a row from another sheet when certain criteria are met. When I go to type in the name of the sheet I am trying to transfer the rows to, it does not show up in my options. However, when I try the same thing on that transfer sheet, the…
Top 10 for the month.
I have a sheet with a count formula and rank formula. I also have a report from that sheet that give me the top 10 I also have a dashboard metric from the report that visualizes the top 10 in a graph. I want to show only the current month in the graph, how do I do this? Do I need to create 12 different reports, one for…
HOW-DO-I: Send All Row Attachments when PDF is generated?
I'm trying to attach all row attachments to an email using automations. The problem is that the system seems to only include attachments that were generated by that process, and the files I need attached are from two different processes. Files: image.png - Uploaded to the form. It currently shows in the approval page (Not…

Help shape the future of Smartsheet.
Share your ideas and feature requests.