\n <\/img><\/a>\n <\/div>\n<\/div>\n <\/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":108553,"type":"question","name":"Formula help","excerpt":"I want text to generate in cell based off of another cell. I want cell with text \"Knowledge Card - Access\" to generate \"kccard\" in another cell. I want Knowledge Card to abbreviate to \"kc\" and I want the word after the hyphen no matter what the word is to appear right after.","snippet":"I want text to generate in cell based off of another cell. I want cell with text \"Knowledge Card - Access\" to generate \"kccard\" in another cell. I want Knowledge Card to…","categoryID":321,"dateInserted":"2023-08-04T18:43:59+00:00","dateUpdated":null,"dateLastComment":"2023-08-07T12:20:47+00:00","insertUserID":162413,"insertUser":{"userID":162413,"name":"kpierson109","url":"https:\/\/community.smartsheet.com\/profile\/kpierson109","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-07T13:06:00+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-07T14:20:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":30,"score":null,"hot":3382588486,"url":"https:\/\/community.smartsheet.com\/discussion\/108553\/formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108553\/formula-help","format":"Rich","lastPost":{"discussionID":108553,"commentID":389166,"name":"Re: Formula help","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389166#Comment_389166","dateInserted":"2023-08-07T12:20:47+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-07T14:20:54+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-07T10:44:29+00:00","dateAnswered":"2023-08-04T19:28:01+00:00","acceptedAnswers":[{"commentID":389031,"body":"
In that case you would use<\/p>
=\"kc\" + RIGHT([Column Name]@row, LEN([Column name]@row) - (FIND(\"-\", [Column Name]@row) + 2))<\/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":108543,"type":"question","name":"This should be a no brainer, but...","excerpt":"I am trying to figure out how to center or right align the symbols in a symbols field on a dashboard. And while it should be an easy thing to do, I cannot for the life of me figure out how to do it. See the image attached. The green dots are what I want to center. I'd also like to be able to spread out each label so that…","snippet":"I am trying to figure out how to center or right align the symbols in a symbols field on a dashboard. And while it should be an easy thing to do, I cannot for the life of me…","categoryID":321,"dateInserted":"2023-08-04T16:31:15+00:00","dateUpdated":null,"dateLastComment":"2023-08-07T12:56:24+00:00","insertUserID":159640,"insertUser":{"userID":159640,"name":"Katherine Simpson","url":"https:\/\/community.smartsheet.com\/profile\/Katherine%20Simpson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/EY1XYADLUP90\/n8693BY7J2F39.jpg","dateLastActive":"2023-08-07T12:56:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":159640,"lastUser":{"userID":159640,"name":"Katherine Simpson","url":"https:\/\/community.smartsheet.com\/profile\/Katherine%20Simpson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/EY1XYADLUP90\/n8693BY7J2F39.jpg","dateLastActive":"2023-08-07T12:56:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":45,"score":null,"hot":3382580859,"url":"https:\/\/community.smartsheet.com\/discussion\/108543\/this-should-be-a-no-brainer-but","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108543\/this-should-be-a-no-brainer-but","format":"Rich","lastPost":{"discussionID":108543,"commentID":389192,"name":"Re: This should be a no brainer, but...","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389192#Comment_389192","dateInserted":"2023-08-07T12:56:24+00:00","insertUserID":159640,"insertUser":{"userID":159640,"name":"Katherine Simpson","url":"https:\/\/community.smartsheet.com\/profile\/Katherine%20Simpson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/EY1XYADLUP90\/n8693BY7J2F39.jpg","dateLastActive":"2023-08-07T12:56:30+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\/G31BS0PD1BAC\/capture-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-07T12:56:27+00:00","dateAnswered":"2023-08-05T06:42:02+00:00","acceptedAnswers":[{"commentID":389076,"body":"
Hi Katherine,<\/p>
You can make the label on one line by dragging the corner 1 to make the widget bigger enough, and center the symbol by selecting \"Use formatting from source\" icon 2 (make sure to center the symbol in your source sheet). <\/p>
Hope this works for you.<\/p>
\n
\n
\n <\/img><\/a>\n <\/div>\n<\/div>\n <\/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":4921,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
Trending in Smartsheet Basics
How can I tell if I have given access to multiple people to view a dashboard? How do I give multiple access to a dashboard?
Formula help I want text to generate in cell based off of another cell. I want cell with text "Knowledge Card - Access" to generate "kccard" in another cell. I want Knowledge Card to abbreviate to "kc" and I want the word after the hyphen no matter what the word is to appear right after.
This should be a no brainer, but... I am trying to figure out how to center or right align the symbols in a symbols field on a dashboard. And while it should be an easy thing to do, I cannot for the life of me figure out how to do it. See the image attached. The green dots are what I want to center. I'd also like to be able to spread out each label so that…