金融

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-07T18:22:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":147,"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-07T18:22:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":3980,"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":436,"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":244,"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}]},{"discussionID":90897,"type":"question","name":"Refund Tracking Smartsheet- Ideas or Template","excerpt":"Good Afternoon Everyone, I am overseeing customer refunds for our company. Our company requires customers to make a refund preference so when there is a refund due to them, we can deliver it to them as quickly as possible. However, because many of them do not make a preference the customer refunds are returned by our bank…","categoryID":321,"dateInserted":"2022-05-07T00:49:46+00:00","dateUpdated":null,"dateLastComment":"2022-05-11T17:36:44+00:00","insertUserID":147776,"insertUser":{"userID":147776,"name":"Rlorenzana","url":"https:\/\/community.smartsheet.com\/profile\/Rlorenzana","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-20T21:56:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":147776,"lastUser":{"userID":147776,"name":"Rlorenzana","url":"https:\/\/community.smartsheet.com\/profile\/Rlorenzana","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-20T21:56:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":352,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/90897\/refund-tracking-smartsheet-ideas-or-template","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/90897\/refund-tracking-smartsheet-ideas-or-template","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-05-07T01:23:37+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"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":53816,"type":"discussion","name":"Quickbooks & Smartsheet","excerpt":"So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for invoices): The power of Smartsheet i.e. (approvals, communication, notes) makes this a beautiful…","categoryID":320,"dateInserted":"2019-07-26T20:23:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-04-12T15:30:33+00:00","insertUserID":21126,"insertUser":{"userID":21126,"name":"JeremiahHorstick","url":"https:\/\/community.smartsheet.com\/profile\/JeremiahHorstick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/5b\/45\/n5b45eb0c1a48afae956282248c8ad587.jpg","dateLastActive":"2023-06-06T17:27:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":21126,"lastUser":{"userID":21126,"name":"JeremiahHorstick","url":"https:\/\/community.smartsheet.com\/profile\/JeremiahHorstick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/5b\/45\/n5b45eb0c1a48afae956282248c8ad587.jpg","dateLastActive":"2023-06-06T17:27:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":33,"countViews":9170,"score":2,"hot":35,"url":"https:\/\/community.smartsheet.com\/discussion\/53816\/quickbooks-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/53816\/quickbooks-smartsheet","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"},{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"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}]},{"discussionID":89522,"type":"question","name":"How do I get a sum for each location (Room 600-605) excluding expired materials?","excerpt":"In this first image the \"Complete Count QTY\" column sums the materials excluding expired materials. This works perfectly. In this image you can see my attempt at getting a sum for Room 605 in the \"Location Specific QTY\" column excluding expired materials. This is where I have a problem. Ideally this would read 4 in the…","categoryID":322,"dateInserted":"2022-03-29T19:00:27+00:00","dateUpdated":null,"dateLastComment":"2022-03-31T15:32:21+00:00","insertUserID":145234,"insertUser":{"userID":145234,"name":"Ian777","url":"https:\/\/community.smartsheet.com\/profile\/Ian777","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-03-31T15:44:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":145984,"lastUser":{"userID":145984,"name":"Jon Mark H","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jon%20Mark%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A6Fcn3BmhHw!BZteQQQa9Do!Rgtj3p-fNgN","dateLastActive":"2023-05-31T20:48:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":140,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/89522\/how-do-i-get-a-sum-for-each-location-room-600-605-excluding-expired-materials","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/89522\/how-do-i-get-a-sum-for-each-location-room-600-605-excluding-expired-materials","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/925N2J2AG73N\/complete-count.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Complete Count.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-03-30T11:35:43+00:00","dateAnswered":"2022-03-29T22:02:34+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">