Gantt Bar with Milestone

Jill Markham
Jill Markham ✭✭✭
inSmartsheet Basics

Is there a way to include a milestone marker on the Gantt bar? In the example below, we would like to show the go-live date as a milestone along the Gantt bar of the execution phase.

Golive.png


Tags:
· Share on Facebook Share on Twitter

Best Answer

Answers

Categories

Hi @Adrià Termes<\/a> <\/p>

You can do this using a cross sheet reference.<\/p>

=JOIN(COLLECT({TeamTeam}, {TeamDepartment}, Department@row), \", \")<\/p>

TeamTeam references the Team column on the Team sheet, and TeamDepartment references the Department column on the Team sheet.<\/p>

Hope this helps.<\/p>

Matthew<\/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":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":112256,"type":"question","name":"Dashboard Views","excerpt":"It would be helpful to know how many views a dashboard is getting to see if it's effective","snippet":"It would be helpful to know how many views a dashboard is getting to see if it's effective","categoryID":321,"dateInserted":"2023-10-27T13:16:00+00:00","dateUpdated":"2023-10-27T14:23:56+00:00","dateLastComment":"2023-10-27T14:24:23+00:00","insertUserID":153592,"insertUser":{"userID":153592,"name":"nancy.mina","url":"https:\/\/community.smartsheet.com\/profile\/nancy.mina","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!WTjeHghqMDQ!hHtd4ZRALXo!6Fyi9bnhkuz","dateLastActive":"2023-10-27T14:07:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-10-27T15:53:17+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":16,"score":1,"hot":3396831323,"url":"https:\/\/community.smartsheet.com\/discussion\/112256\/dashboard-views","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112256\/dashboard-views","format":"Rich","lastPost":{"discussionID":112256,"commentID":402018,"name":"Re: Dashboard Views","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402018#Comment_402018","dateInserted":"2023-10-27T14:24:23+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-10-27T15:53:17+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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-10-27T14:24:11+00:00","dateAnswered":"2023-10-27T13:38:24+00:00","acceptedAnswers":[{"commentID":402006,"body":"

Hey @nancy.mina<\/a> <\/p>

If you're either the Owner or the Admin of a Dashboard on a Business or Enterprise plan, you can see Views by going to the Activity Log<\/strong> of the Dashboard (File > Activity Log).<\/p>

Here you can add a Date Range and filter by the Views action:<\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n

Can you clarify if this resolves your current request or if you had more specifics to your Idea?<\/p>

Thanks!<\/p>

Genevieve<\/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":1},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":112230,"type":"question","name":"Automation Question","excerpt":"Hello, I am new to smartsheets and I'm trying to use the automation tool to auto-populate some of the information on my sheet so it doesn't have to be filled in manually but it doesn't seem to want to work. I have an interview tracker and what I want to do is if I select \"No Show\" under the attendance column that it…","snippet":"Hello, I am new to smartsheets and I'm trying to use the automation tool to auto-populate some of the information on my sheet so it doesn't have to be filled in manually but it…","categoryID":321,"dateInserted":"2023-10-26T17:45:05+00:00","dateUpdated":null,"dateLastComment":"2023-10-26T18:25:11+00:00","insertUserID":169140,"insertUser":{"userID":169140,"name":"Ashley.Lowe","title":"Talent Acquisition Manager","url":"https:\/\/community.smartsheet.com\/profile\/Ashley.Lowe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-27T15:05:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":169140,"lastUser":{"userID":169140,"name":"Ashley.Lowe","title":"Talent Acquisition Manager","url":"https:\/\/community.smartsheet.com\/profile\/Ashley.Lowe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-27T15:05:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":45,"score":null,"hot":3396690016,"url":"https:\/\/community.smartsheet.com\/discussion\/112230\/automation-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112230\/automation-question","format":"Rich","lastPost":{"discussionID":112230,"commentID":401906,"name":"Re: Automation Question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401906#Comment_401906","dateInserted":"2023-10-26T18:25:11+00:00","insertUserID":169140,"insertUser":{"userID":169140,"name":"Ashley.Lowe","title":"Talent Acquisition Manager","url":"https:\/\/community.smartsheet.com\/profile\/Ashley.Lowe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-27T15:05:34+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/HC6W5SI7W5CO\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/HC6W5SI7W5CO\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/HC6W5SI7W5CO\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/HC6W5SI7W5CO\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/HC6W5SI7W5CO\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/HC6W5SI7W5CO\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-26T18:34:08+00:00","dateAnswered":"2023-10-26T18:21:41+00:00","acceptedAnswers":[{"commentID":401903,"body":"

Ashley, you have perplexed me completely! I have no idea how that happened!<\/p>


<\/p>

Attempt two: can you update your trigger into \"When Rows Are Changed\"<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

Then, delete all of these erroneous rows and hit save.<\/p>

Finally, add \"No Show\" into like three rows. Save your sheet, and reload (automation takes a second to run completely). <\/p>

Is your \"Attendance\" column set up as a dropdown or as a text?<\/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":5205,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • Compressing based on a column label different row data points in one cell

    Hi all. I am trying to do a rather complex operation on Smartsheet, generally performed in programming. I have two different sheets: one for Departments and another one for teams. Both sheets can be linked through the interrelation they have, although the teams sheet have multiple times the department across rows (E-G:…

  • Dashboard Views

    It would be helpful to know how many views a dashboard is getting to see if it's effective

  • Automation Question

    Hello, I am new to smartsheets and I'm trying to use the automation tool to auto-populate some of the information on my sheet so it doesn't have to be filled in manually but it doesn't seem to want to work. I have an interview tracker and what I want to do is if I select "No Show" under the attendance column that it…

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

 Watch video