Formula help

kpierson109 ✭

08/04/23 inSmartsheet Basics

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.

0 ·

Best Answer

Paul Newcome ✭✭✭✭✭✭

08/04/23 Answer ✓

In that case you would use

= " kc " +正确的([Column Name]@row, LEN([Column name]@row) - (FIND("-", [Column Name]@row) + 2))

10 xviz.com

0 · Share on Facebook Share on Twitter

Answers

Paul Newcome ✭✭✭✭✭✭

08/04/23 edited 08/04/23

So are you looking for two different formulas? You outline above two separate outputs.

"kccard"

vs

"kc" and the word after the hyphen

10 xviz.com

0 · Share on Facebook Share on Twitter
kpierson109 ✭

08/04/23

I need a formula for the second. I will have cells that have any word after the hyphen.

"Knowledge Card - ______"

0 · Share on Facebook Share on Twitter
Paul Newcome ✭✭✭✭✭✭

08/04/23 Answer ✓

In that case you would use

= " kc " +正确的([Column Name]@row, LEN([Column name]@row) - (FIND("-", [Column Name]@row) + 2))

10 xviz.com

0 · Share on Facebook Share on Twitter
kpierson109 ✭

08/04/23

Thank you!

0 · Share on Facebook Share on Twitter
Paul Newcome ✭✭✭✭✭✭

08/07/23

Happy to help.️

10 xviz.com

0 · Share on Facebook Share on Twitter

Categories

Hi @David Sprague<\/a>, <\/p>

I hope you're well and safe!<\/p>

There's a known issue at the moment.<\/p>

I'll get back to the post if I can find the thread.<\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

\n \n https:\/\/community.smartsheet.com\/discussion\/108880\/recover-a-row-that-was-accidentally-moved-then-deleted\n <\/a>\n<\/div>\n
Hey @GlennJo<\/a>,<\/p>
the sheet should be available in the owner of the sheet, deleted files. If it is specifically a row of data that was deleted, you can try checking the activity log to see if it shows the removed data there.<\/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":108822,"type":"question","name":"Activity Log | Rows Deleted Filter","excerpt":"I've got a conundrum on my hands where a record has gone missing. In the Activity Log, I'm able to find the record of when it was created. However, there is nothing I'm seeing indicating that it was deleted (even though the Activity Log doesn't have a specific filter for this, I traced through the log for the past 11 days…","snippet":"I've got a conundrum on my hands where a record has gone missing. In the Activity Log, I'm able to find the record of when it was created. However, there is nothing I'm seeing…","categoryID":321,"dateInserted":"2023-08-10T21:46:08+00:00","dateUpdated":null,"dateLastComment":"2023-08-10T22:01:16+00:00","insertUserID":121055,"insertUser":{"userID":121055,"name":"Jake Gustafson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jake%20Gustafson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-lnW91tuGTw!bO9UmyNQSXQ!WUYBUm0HF6t","dateLastActive":"2023-08-11T20:29:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":121055,"lastUser":{"userID":121055,"name":"Jake Gustafson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jake%20Gustafson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-lnW91tuGTw!bO9UmyNQSXQ!WUYBUm0HF6t","dateLastActive":"2023-08-11T20:29:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":37,"score":null,"hot":3383410044,"url":"https:\/\/community.smartsheet.com\/discussion\/108822\/activity-log-rows-deleted-filter","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108822\/activity-log-rows-deleted-filter","format":"Rich","tagIDs":[447],"lastPost":{"discussionID":108822,"commentID":390131,"name":"Re: Activity Log | Rows Deleted Filter","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390131#Comment_390131","dateInserted":"2023-08-10T22:01:16+00:00","insertUserID":121055,"insertUser":{"userID":121055,"name":"Jake Gustafson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jake%20Gustafson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-lnW91tuGTw!bO9UmyNQSXQ!WUYBUm0HF6t","dateLastActive":"2023-08-11T20:29:49+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\/SIFFD1TSN3Q6\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-10T22:01:20+00:00","dateAnswered":"2023-08-10T22:01:16+00:00","acceptedAnswers":[{"commentID":390131,"body":"
Ok, I found it. Classic case of submit something for help, then find the answer. I think what may have happened previously, is that I turned on all the filters, but since there isn't one for a Deleted Row, maybe the Deleted Row was hidden. When I came back, I didn't click anything on the filters for the Activity Log and when scrolling through looking for the 'magic' delete word, I found the record I was looking for.<\/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":447,"urlcode":"activity-log","name":"Activity Log"}]}],"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":4941,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

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