Link to a Smartsheet section

PMOGal
PMOGal ✭✭
inSmartsheet Basics

I have separate Smartsheet with ties to tasks in another detailed Smartsheet. Can I create a link that goes to that particular task so that people can see all subtasks and comments? In the old days used to create anchors in HTML to accomplish this. Thanks.

Tags:
· Share on Facebook Share on Twitter

Best Answer

Answers

Categories

Is there any data in the source file?<\/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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}]},{"discussionID":109378,"type":"question","name":"How do I change the font (size and type) in a pie chart?","excerpt":"Hello, As per the attached screen shot, I am trying to change the size of the font (%ages) in the pie chart but unable to do so? I changed the font in the legend but not sure if it is possible to change it in the actual percentages? Please advise. Thanks","snippet":"Hello, As per the attached screen shot, I am trying to change the size of the font (%ages) in the pie chart but unable to do so? I changed the font in the legend but not sure if…","categoryID":321,"dateInserted":"2023-08-24T06:25:39+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T05:29:52+00:00","insertUserID":158545,"insertUser":{"userID":158545,"name":"Safiya B","url":"https:\/\/community.smartsheet.com\/profile\/Safiya%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T05:28:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":158545,"lastUser":{"userID":158545,"name":"Safiya B","url":"https:\/\/community.smartsheet.com\/profile\/Safiya%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T05:28:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":23,"score":null,"hot":3385800931,"url":"https:\/\/community.smartsheet.com\/discussion\/109378\/how-do-i-change-the-font-size-and-type-in-a-pie-chart","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109378\/how-do-i-change-the-font-size-and-type-in-a-pie-chart","format":"Rich","lastPost":{"discussionID":109378,"commentID":392520,"name":"Re: How do I change the font (size and type) in a pie chart?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392520#Comment_392520","dateInserted":"2023-08-25T05:29:52+00:00","insertUserID":158545,"insertUser":{"userID":158545,"name":"Safiya B","url":"https:\/\/community.smartsheet.com\/profile\/Safiya%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T05:28:53+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-08-25T05:28:50+00:00","dateAnswered":"2023-08-24T09:55:27+00:00","acceptedAnswers":[{"commentID":392270,"body":"

@Safiya B<\/a> <\/p>

Sadly you are unable to change the label font and size. Have you tried changing to a Semicircle pie at all? That sometimes sorts out labelling issues!<\/p>

Kind regards<\/p>

Debbie<\/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":109402,"type":"question","name":"Reminder workflow not working","excerpt":"I have a workflow specific to a rush order. When rush order is stared on the form, the workflow triggers to run hourly. Then there is a condition \"If rush order is \"checked\" and status is \"submitted\" instead of accepted or declined it sends a reminder to the approver. The alert works once but doesnt continue to send…","snippet":"I have a workflow specific to a rush order. When rush order is stared on the form, the workflow triggers to run hourly. Then there is a condition \"If rush order is \"checked\" and…","categoryID":321,"dateInserted":"2023-08-24T15:07:16+00:00","dateUpdated":null,"dateLastComment":"2023-08-24T15:30:04+00:00","insertUserID":162330,"insertUser":{"userID":162330,"name":"d.hickey","title":"David Hickey","url":"https:\/\/community.smartsheet.com\/profile\/d.hickey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-24T18:10:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-24T20:19:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":28,"score":null,"hot":3385782440,"url":"https:\/\/community.smartsheet.com\/discussion\/109402\/reminder-workflow-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109402\/reminder-workflow-not-working","format":"Rich","lastPost":{"discussionID":109402,"commentID":392368,"name":"Re: Reminder workflow not working","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392368#Comment_392368","dateInserted":"2023-08-24T15:30:04+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-24T20:19:17+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-08-24T15:45:06+00:00","dateAnswered":"2023-08-24T15:30:04+00:00","acceptedAnswers":[{"commentID":392368,"body":"

Ok. So the trigger is the issue. You have it set to only grab rows that have been added or changed within the past hour.<\/p>


<\/p>

My suggestion (tedious but effective) is to adjust the trigger to be daily (date based with custom selection of every 1 day) and run at a specific hour with the same conditions.<\/p>


<\/p>

Duplicate the workflow and adjust the hour to be the next hour. Duplicate again and adjust the hour. So on and so forth for each hour that you want to run the workflow on (this allows you to restrict it to only during business hours so someone isn't getting a ton of emails all about the same thing while they are sleeping).<\/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":4986,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • Error When Importing Google Sheet

    I was able to import this sheet successfully once as a test. Now when I try to import I get the attached error that states that the Excel file is invalid, but I didn't select to import and excel file! Any help would be appreciated!

  • How do I change the font (size and type) in a pie chart?

    Hello, As per the attached screen shot, I am trying to change the size of the font (%ages) in the pie chart but unable to do so? I changed the font in the legend but not sure if it is possible to change it in the actual percentages? Please advise. Thanks

  • Reminder workflow not working

    I have a workflow specific to a rush order. When rush order is stared on the form, the workflow triggers to run hourly. Then there is a condition "If rush order is "checked" and status is "submitted" instead of accepted or declined it sends a reminder to the approver. The alert works once but doesnt continue to send…

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

 Watch video