Gantt chart task bar colour

I wondering if anyone had this exercise to change the colour of the task bar colour in Gantt chart with formal

If yes so I need your help please share how you did 🙂

I have attached excel sheet

screenshot.webp.PDF

it dose what exactly I'm doing right now but I want to do it with smartsheet Gantt chart

Please note I know how to do it manually one by one, I'm looking for formula to do the job.

Thank you.

Find more posts tagged with

Accepted answers

@Frank Falco Hi frank thank you i got it

Thank you :)

All comments

You can use conditional formatting on a row to set the Task Bar color. See below for some examples.

@Frank Falco Hi frank thank you i got it

Thank you :)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.