Not all "Actual" bar show in gantt chart
Hi,
Some of the tasks/sub-activities in my gantt chart do not show the "actual" bar even there is a reported progress (e.g. below activity with 25% progress).
I'd appreciate any advise.
@Andrée Starå@Genevieve P.perhaps you can assist?
Thanks
IPC
Best Answer
-
Genevieve P. Employee Admin
Hi@IPC
Percentage progress bars won't show in a Report - you'll need to view this in the underlying sheet to see the progress, as you've found.
Please submit your feature request to the Product team by creating anIdea Postin theSmartsheet Product Feedback and Ideas topichere in the Community. This will allow other users to vote on your enhancement idea!
Cheers,
Genevieve
Answers
-
Kleerfyre ✭✭✭✭✭✭
This bar is spanning from around April 20th to past May 14th. Do you have dates set on these items? If you have 25%, but the work wasn't done until like May 20th, it might not show. I think we need to see a bit more information from your sheet to be able to help.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
IPC ✭✭
Thanks for your reply.
Here is another example where the "% of complete" does not reflect as a bar in the gantt chart.
Thanks in advance for your assistance.
Kind regards,
IPC
-
Kleerfyre ✭✭✭✭✭✭
Do you potentially have a critical path set up? Check your properties on that task. Is there any dependencies on this task?
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
IPC ✭✭
@Kleerfyrenone. they are independent tasks.
-
Kleerfyre ✭✭✭✭✭✭
That is quite odd. So you could try deleting the row then re-entering it and see if that fixes the issue. You could also look in the logs of the sheet to see if you see anything there as well.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
IPC ✭✭
I have figured it out. in the Project Settings, the %Completed Column setting was point to another column. (Figure 1)
As you can see here, it now shows the "actual" bar on top of the "Planned". Now I have another related inquiry.
Figure 1: Grid Sheet
Why is it that when I use the same as "report" in the dashboard, it doesn't show the "actual" bars?
Figure 2: Report Sheet
Any idea?
thanks
-
Genevieve P. Employee Admin
Hi@IPC
Percentage progress bars won't show in a Report - you'll need to view this in the underlying sheet to see the progress, as you've found.
Please submit your feature request to the Product team by creating anIdea Postin theSmartsheet Product Feedback and Ideas topichere in the Community. This will allow other users to vote on your enhancement idea!
Cheers,
Genevieve
-
IPC ✭✭
Thanks@Genevieve P.Thanks for the info. I will post it in Idea Post.
Help Article Resources
Categories
=IF(COUNT(CHILDREN()) = 0, IF(OR(Done@row = 1, [N\/A]@row = 1), 1, 0), AVG(CHILDREN()))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":108195,"type":"question","name":"COUNTIF Function Not Working Correctly","excerpt":"Hello, I have a COUNTIF function I am using to count all cells that are 'Blank' in a column. We should have one result, but the formula is showing as zero. Any thoughts on this one? =COUNTIF([Account Dashboard]:[Account Dashboard], \" \")","snippet":"Hello, I have a COUNTIF function I am using to count all cells that are 'Blank' in a column. We should have one result, but the formula is showing as zero. Any thoughts on this…","categoryID":322,"dateInserted":"2023-07-27T16:41:32+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T19:11:08+00:00","insertUserID":164192,"insertUser":{"userID":164192,"name":"ewitt19205","url":"https:\/\/community.smartsheet.com\/profile\/ewitt19205","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mo_vH-5dWnI!5OcveUI6Zjo!UtWovaSRry_","dateLastActive":"2023-07-27T19:07:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164192,"lastUser":{"userID":164192,"name":"ewitt19205","url":"https:\/\/community.smartsheet.com\/profile\/ewitt19205","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mo_vH-5dWnI!5OcveUI6Zjo!UtWovaSRry_","dateLastActive":"2023-07-27T19:07:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3380962360,"url":"https:\/\/community.smartsheet.com\/discussion\/108195\/countif-function-not-working-correctly","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108195\/countif-function-not-working-correctly","format":"Rich","lastPost":{"discussionID":108195,"commentID":387638,"name":"Re: COUNTIF Function Not Working Correctly","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387638#Comment_387638","dateInserted":"2023-07-27T19:11:08+00:00","insertUserID":164192,"insertUser":{"userID":164192,"name":"ewitt19205","url":"https:\/\/community.smartsheet.com\/profile\/ewitt19205","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mo_vH-5dWnI!5OcveUI6Zjo!UtWovaSRry_","dateLastActive":"2023-07-27T19:07:23+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-27T19:10:56+00:00","dateAnswered":"2023-07-27T16:47:29+00:00","acceptedAnswers":[{"commentID":387588,"body":"