金融

3, \",\" + MID([Unit…","categoryID":322,"dateInserted":"2022-06-23T20:08:49+00:00","dateUpdated":"2022-06-28T12:43:04+00:00","dateLastComment":"2022-06-28T12:38:43+00:00","insertUserID":143257,"insertUser":{"userID":143257,"name":"Bobby1","url":"https:\/\/community.smartsheet.com\/profile\/Bobby1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-17T16:15:05+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-06-23T18:55:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":155,"score":null,"hot":3312436652,"url":"https:\/\/community.smartsheet.com\/discussion\/92596\/dollar-values-keeping-the-comma-delimiters","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92596\/dollar-values-keeping-the-comma-delimiters","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/4WAKAUA7PTRU\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-27T11:27:07+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":42241,"type":"discussion","name":"Text Wrapping is not working.","excerpt":"Hi, I've created a new sheet and a form, I've applied text wrap to the columns that might need it and I've tested certain cells, inputting more text than the cell than would be visible. I've clicked an unclicked the text wrap button on the menu... nothing is happening. I've saved and refreshed the sheet...still no text…","categoryID":321,"dateInserted":"2019-02-25T11:05:55+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-06-06T09:01:26+00:00","insertUserID":79866,"insertUser":{"userID":79866,"name":"katjie.carpenter79866","url":"https:\/\/community.smartsheet.com\/profile\/katjie.carpenter79866","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-25T11:01:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"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-06-23T18:55:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":4065,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/42241\/text-wrapping-is-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/42241\/text-wrapping-is-not-working","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":238,"urlcode":"Finance","name":"Finance"}],"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}]},{"discussionID":91486,"type":"question","name":"Need Help Sorting & Grouping \"Day\" Data By \"Week\"","excerpt":"I'm brand new to functions and Smartsheets in general so please bear with me as I attempt to learn with you all. I've read over the functions documentation and to be honest, it's a little over my head. I'm trying to suss out a step by step otherwise I get lost. But I'm hoping I'll get there eventually! Here's the nuts of…","categoryID":322,"dateInserted":"2022-05-25T17:00:17+00:00","dateUpdated":null,"dateLastComment":"2022-05-25T17:13:09+00:00","insertUserID":148384,"insertUser":{"userID":148384,"name":"Casey Jones","url":"https:\/\/community.smartsheet.com\/profile\/Casey%20Jones","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HGDpX7p_hfs!nYVdP0IjE2Q!E8nCccrf5ZC","dateLastActive":"2022-05-26T20:52:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":28096,"lastUser":{"userID":28096,"name":"Dale Murphy","url":"https:\/\/community.smartsheet.com\/profile\/Dale%20Murphy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-01\/09\/85\/n09854db3c85d2fcac04eb0a42036548e.jpg","dateLastActive":"2023-05-17T20:43:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":459,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/91486\/need-help-sorting-grouping-day-data-by-week","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91486\/need-help-sorting-grouping-day-data-by-week","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/LG41IN401K3V\/screen-shot-2022-05-25-at-9-51-27-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2022-05-25 at 9.51.27 AM.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-05-25T17:13:09+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":86387,"type":"question","name":"Track inventory movement in multiple warehouse locations","excerpt":"Hi, We would like to track inventory movement between multiple warehouse locations, there is no need to track stock value\/sales, just need to track inventory movement between locations and the inventory balance Warehouse: Warehouse A, Warehouse B Item: Item A, Item B Current Stock: - Warehouse A, Item A: 15 - Warehouse A,…","categoryID":322,"dateInserted":"2022-01-11T03:35:12+00:00","dateUpdated":null,"dateLastComment":"2022-05-12T17:00:41+00:00","insertUserID":143318,"insertUser":{"userID":143318,"name":"Ashley356","url":"https:\/\/community.smartsheet.com\/profile\/Ashley356","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJxDsqUBx1fnBII4HrHYvt6kblV-aAczGUA5uwrE=s96-c","dateLastActive":"2022-04-21T07:24:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":146362,"lastUser":{"userID":146362,"name":"AnnieR","url":"https:\/\/community.smartsheet.com\/profile\/AnnieR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-21T15:11:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":252,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/86387\/track-inventory-movement-in-multiple-warehouse-locations","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/86387\/track-inventory-movement-in-multiple-warehouse-locations","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-01-12T00:22:25+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">