甘特条形颜色报告不匹配color in Sheet

I have a Report that references timelines in a Sheet, and the colors do not match between the two. Why is this and how do I fix it? At first it looked like the report bar colors were importing the colors of children tasks, but even after updating those it won't adjust on the report.

Untitled_report_-_Smartsheet_com.jpg
XNRGY_AZ_Schedule_Phase_1_-_Smartsheet_com.jpg


Answers

  • In my post, first image is sheet view and second image is report view

  • Melitta
    Melitta ✭✭✭✭

    @shawnb12,

    In the Gantt, control/right click and this menu will open up. Click on Color Settings and the colors can be set for each of your timelines.

    Screen Shot 2023-09-15 at 7.37.21 PM.png
    Screen Shot 2023-09-15 at 7.41.13 PM.png






    I hope this helps.

    Melitta

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭

    @shawnb12

    Hi Shawn

    In the screen shot of the sheet, I can see the colours in the Gannt but I can't tell the level of the row associated with the rows (i.e. whether the row is a Parent or Child row)

    In the Report, all the rows are Parent rows, which means they are Summary Rows. In Smartsheet Summary Row Gannt colour is Grey by default. The summary row colour takes precedent over any child row conditional formatting.

    Can your report find the Child rows rather than the Parent rows, then if so, do you see the colours filtering through?

    Just a thought...

    Kind regards

    Debbie Sawyer- Chief Smartsheet Solutions Officer (CSSO)


    RaFLZADwxPlIdaUSlkVwf4pKuVBIBnNkQjN9U6RSHg8na7ayJNR2BK6IKWyXZ8c2uUWi-gGwDnUQrryXTDiBx8kyRSnEjBqvEnmOJAIGq17AnBPTtcbK5oXRBb2IUcqChOToQtr4

@Ghaven<\/a> - The choice between Smartsheet and Jira really comes down to what you're looking to get done and who's on your team. If we're talking about a dev-heavy team working on complex, technical projects with tons of requirements, then Jira's a no-brainer. It's built for that level of detail and collaboration. But hey, if your team's a mix of tech and non-tech folks, or you're juggling different types of projects, Smartsheet's versatility and user-friendly layout could be the better route. Just keep in mind things like cost, how well these platforms play with your existing tech stack, and the time it'll take for everyone to get up to speed on a new system. So, it's not a one-size-fits-all answer; it's about aligning the tool with your team's specific needs and workflow. Hope that helps a little 👍️<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":110373,"type":"question","name":"10 digit fixed numeric field","excerpt":"Hi, I have few fields where I want to add a validation\/control user to force doing the correct entry - e.g. PO# shouldn't be more or less than 10 digits. Is it possible? They do these entries via Form. I see their are new validations numeric\/text etc...they don't help what I need. Also, Can we trigger any flash alert for…","snippet":"Hi, I have few fields where I want to add a validation\/control user to force doing the correct entry - e.g. PO# shouldn't be more or less than 10 digits. Is it possible? They do…","categoryID":321,"dateInserted":"2023-09-17T21:57:39+00:00","dateUpdated":null,"dateLastComment":"2023-09-18T11:13:34+00:00","insertUserID":165902,"insertUser":{"userID":165902,"name":"Arts B.","url":"https:\/\/community.smartsheet.com\/profile\/Arts%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T14:35:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":165902,"lastUser":{"userID":165902,"name":"Arts B.","url":"https:\/\/community.smartsheet.com\/profile\/Arts%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T14:35:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":23,"score":null,"hot":3390024673,"url":"https:\/\/community.smartsheet.com\/discussion\/110373\/10-digit-fixed-numeric-field","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110373\/10-digit-fixed-numeric-field","format":"Rich","tagIDs":[204,254],"lastPost":{"discussionID":110373,"commentID":395685,"name":"Re: 10 digit fixed numeric field","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/395685#Comment_395685","dateInserted":"2023-09-18T11:13:34+00:00","insertUserID":165902,"insertUser":{"userID":165902,"name":"Arts B.","url":"https:\/\/community.smartsheet.com\/profile\/Arts%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T14:35:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-18T11:33:19+00:00","dateAnswered":"2023-09-18T11:13:34+00:00","acceptedAnswers":[{"commentID":395685,"body":"

Thanks, Tim, for replying. Yes, I read more on the community about and found the same workaround....I already applied it.<\/p>

(my users are floor workers and works in the shift-only issue here is they don't check emails that often.) so this workaround has limitation in this case. But I'll mark this close as, no actual solution available in Smartsheet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":110349,"type":"question","name":"Need to check and uncheck a box based on a percentage being above 0 and less than 100.","excerpt":"I have been trying different variations of the below but it always errors out until I start checking boxes and when the percentage reaches 100 the box is still checked. The checkbox in question is in a column named Inprocess, and the percentage in in a column named Percent completed. =IF([Percent Completed]@row > 0, true,…","snippet":"I have been trying different variations of the below but it always errors out until I start checking boxes and when the percentage reaches 100 the box is still checked. The…","categoryID":321,"dateInserted":"2023-09-15T18:43:40+00:00","dateUpdated":null,"dateLastComment":"2023-09-15T19:35:13+00:00","insertUserID":154002,"insertUser":{"userID":154002,"name":"SmartSheet Newbie","url":"https:\/\/community.smartsheet.com\/profile\/SmartSheet%20Newbie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/OLZT5TMCDLUA\/nLGJGXEA8PX07.png","dateLastActive":"2023-09-19T14:33:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":52616,"lastUser":{"userID":52616,"name":"Nic Larsen","url":"https:\/\/community.smartsheet.com\/profile\/Nic%20Larsen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2023-09-19T15:04:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":38,"score":null,"hot":3389611733,"url":"https:\/\/community.smartsheet.com\/discussion\/110349\/need-to-check-and-uncheck-a-box-based-on-a-percentage-being-above-0-and-less-than-100","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110349\/need-to-check-and-uncheck-a-box-based-on-a-percentage-being-above-0-and-less-than-100","format":"Rich","lastPost":{"discussionID":110349,"commentID":395617,"name":"Re: Need to check and uncheck a box based on a percentage being above 0 and less than 100.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/395617#Comment_395617","dateInserted":"2023-09-15T19:35:13+00:00","insertUserID":52616,"insertUser":{"userID":52616,"name":"Nic Larsen","url":"https:\/\/community.smartsheet.com\/profile\/Nic%20Larsen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2023-09-19T15:04:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-15T19:29:36+00:00","dateAnswered":"2023-09-15T19:18:57+00:00","acceptedAnswers":[{"commentID":395613,"body":"

Try: =IF([Percent Completed]@row = 1, 0, IF([Percent Completed]@row > 0, 1))<\/p>"},{"commentID":395617,"body":"

@SmartSheet Newbie<\/a> <\/p>

If the % complete = 100% (which is a 1 in a formula), then uncheck which is a 0 value in a checkbox column. <\/p>

If the % complete is greater than 0, check the box (which is a 1 value). <\/p>

If % complete is zero, it will also be unchecked.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5090,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics