Add Ons and Integrations

Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, WorkApps, or Resource Management. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

Discussion List

Categories

Popular Tags

Hi @Sabrain<\/a> <\/p>

See if these will work for you. They separate the text based on the characters: , # $ %<\/p>

Barcode is the column name and each formula is placed in a separate column on the same row as the barcode.<\/p>

=LEFT(Barcode@row, FIND(\",\", Barcode@row) - 1)<\/p>

=MID(Barcode@row, FIND(\",\", Barcode@row) + 1, FIND(\"#\", Barcode@row) - FIND(\",\", Barcode@row) - 1)<\/p>

=MID(Barcode@row, FIND(\"#\", Barcode@row) + 1, FIND(\"$\", Barcode@row) - FIND(\"#\", Barcode@row) - 1)<\/p>

=MID(Barcode@row, FIND(\"$\", Barcode@row) + 1, FIND(\"%\", Barcode@row) - FIND(\"$\", Barcode@row) - 1)<\/p>

=MID(Barcode@row, FIND(\"%\", Barcode@row) + 1, LEN(Barcode@row) - FIND(\"%\", Barcode@row))<\/p>

I hope this is helpful and it works for you!<\/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":105017,"type":"question","name":"Formula won't recognize values as numbers","excerpt":"Hi there! Problem = I have four \"Text\/Number\" columns that I want to average Complexity = the column values are derived from formulas Issue = when I try to average all four columns with =AVG([Stakeholder Score]@row:[Complexity Score]@row) formula, it keeps throwing an error. Even when I try the long way around…","categoryID":321,"dateInserted":"2023-05-09T19:09:44+00:00","dateUpdated":null,"dateLastComment":"2023-05-09T21:17:50+00:00","insertUserID":131611,"insertUser":{"userID":131611,"name":"Layla Morales","url":"https:\/\/community.smartsheet.com\/profile\/Layla%20Morales","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3CjZfyh8C6Q!3AlM_6Q4hzo!RnLEnW7g5Nu","dateLastActive":"2023-05-09T21:14:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":131611,"lastUser":{"userID":131611,"name":"Layla Morales","url":"https:\/\/community.smartsheet.com\/profile\/Layla%20Morales","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3CjZfyh8C6Q!3AlM_6Q4hzo!RnLEnW7g5Nu","dateLastActive":"2023-05-09T21:14:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":51,"score":null,"hot":3367328254,"url":"https:\/\/community.smartsheet.com\/discussion\/105017\/formula-wont-recognize-values-as-numbers","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105017\/formula-wont-recognize-values-as-numbers","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":105017,"commentID":375028,"name":"Re: Formula won't recognize values as numbers","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/375028#Comment_375028","dateInserted":"2023-05-09T21:17:50+00:00","insertUserID":131611,"insertUser":{"userID":131611,"name":"Layla Morales","url":"https:\/\/community.smartsheet.com\/profile\/Layla%20Morales","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3CjZfyh8C6Q!3AlM_6Q4hzo!RnLEnW7g5Nu","dateLastActive":"2023-05-09T21:14:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"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\/1VAC32KIMJHU\/smartsheet-problem.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet problem.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-09T21:14:33+00:00","dateAnswered":"2023-05-09T20:11:36+00:00","acceptedAnswers":[{"commentID":375019,"body":"

@Layla Morales<\/a>, <\/p>

I used the same formulas, used them against text\/number columns with column formulas, and had no trouble. Text auto aligns left. Numbers auto align right. If you haven't set your cell alignment up yet, then by the looks of it yours is coming in as text (string) instead of numbers. I'd be interested in seeing one of the column formulas in your 4 columns that is causing the values to be text instead of numbers.<\/p>

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

You can use the Value() function to convert text to number.<\/p>"},{"commentID":375025,"body":"

@Ray Lindstrom<\/a> this was very insightful! I had no idea the value alignment in the cell told you anything. The formula for the columns is a nesting IF formula based on values in another column to create scores. =IF([column name]@row = \"value1\", \"1\", =IF([column name]@row = \"value2\", \"2\", =IF([column name]@row = \"value3\", \"3\")))<\/strong><\/p>

Would you be able to help me figure out how to convert it into a number from text?<\/p>"},{"commentID":375028,"body":"

@Ray Lindstrom<\/a> I found an article that showed me how to use the VALUE() formula and it worked! Thank you so much for your help!!!<\/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":104996,"type":"question","name":"Automation - Workflow Copy Rows","excerpt":"I'm having an issue with the copy row workflow. When I run the workflow it is copying every row in my sheet not just the row that has the changed Status value. Any thoughts on why this is happening?","categoryID":321,"dateInserted":"2023-05-09T15:07:25+00:00","dateUpdated":null,"dateLastComment":"2023-05-09T17:32:18+00:00","insertUserID":161276,"insertUser":{"userID":161276,"name":"wtaylor","url":"https:\/\/community.smartsheet.com\/profile\/wtaylor","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-09T17:40: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-05-09T17:38:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":29,"score":null,"hot":3367300183,"url":"https:\/\/community.smartsheet.com\/discussion\/104996\/automation-workflow-copy-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104996\/automation-workflow-copy-rows","format":"Rich","lastPost":{"discussionID":104996,"commentID":375004,"name":"Re: Automation - Workflow Copy Rows","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/375004#Comment_375004","dateInserted":"2023-05-09T17:32:18+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-05-09T17:38:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"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\/QC00FA7H3HFS\/2023-05-09-10-05-29.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2023-05-09_10-05-29.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-09T17:05:23+00:00","dateAnswered":"2023-05-09T17:00:43+00:00","acceptedAnswers":[{"commentID":374992,"body":"

If you are using the \"Run Now\" feature, it will ignore the trigger and only look at conditions. Since you do not have any conditions listed, it is going to copy every row.<\/p>


<\/p>

Try testing it by using an actual sheet trigger instead of the \"Run Now\" feature.<\/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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">