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 ✭✭✭✭✭✭

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

Record a date automation isn't working
I set up the automation below, and it's not working. When I change the status of a row to complete, nothing happens. If I go into the automation manager and select "run" or "test" the completion date column fills in with today's date. What am I doing wrong? This should be straight-forward. I've tried building this…
Why are my Task Rows expanded every morning?
I've been using smartsheet for a few years now and never had this issue before, but starting this year, every morning when I go into one of my project sheets at the start of my work day they are ALL expanded. I have parent and child tasks that are 100% completed a year ago that are now suddenly expanded every morning. So…
Where are the AI (formula generation) icons now? 2025
Before, I was used to seeing the AI icon listed on the right side menu, at the bottom. where is the AI formula generator icon now in 2025?

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