支持

500, or losses > than 0, then the \"TOTAL\" cell shows a dollar sign…","categoryID":317,"dateInserted":"2015-04-26T13:54:43+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-27T14:33:23+00:00","insertUserID":1183,"insertUser":{"userID":1183,"name":"Daniel Thornton","url":"https:\/\/community.smartsheet.com\/profile\/Daniel%20Thornton","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-07-22T10:13:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":177,"lastUser":{"userID":177,"name":"Travis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Travis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/30\/n9b30d18a803dd0ccefe2f8f2d8765390.jpg","dateLastActive":"2020-01-21T20:47:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":277,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/181\/money-format-in-cell-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/181\/money-format-in-cell-not-working","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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":134,"type":"discussion","name":"Discussion row is gone. How do I get it back","excerpt":" Hello, I am attaching a screenshot, because I don't know how else to explain this - my discussion row is gone. How do I get it back? - Adam","categoryID":317,"dateInserted":"2015-04-21T15:38:41+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-22T07:19:27+00:00","insertUserID":896,"insertUser":{"userID":896,"name":"Adam Lundquist","url":"https:\/\/community.smartsheet.com\/profile\/Adam%20Lundquist","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-04-10T13:27:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":237,"lastUser":{"userID":237,"name":"Richard Rymill SBP","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Richard%20Rymill%20SBP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/56\/cc\/n56cc5e719e36b8b84e97c4c58049f914.jpg","dateLastActive":"2023-05-04T14:17:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":14,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/134\/discussion-row-is-gone-how-do-i-get-it-back","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/134\/discussion-row-is-gone-how-do-i-get-it-back","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/06\/62\/06625c67ccae530e9df879c3f41db3eb.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2015-04-21 at 3.38.11 PM.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":281,"urlcode":"Support","name":"Support"}],"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":113,"type":"discussion","name":"Recurring Error Window","excerpt":"How do I get rid of an error that keeps coming up everytime I enter Smartsheet. \"You already have a copy of the specified sheet, a new copy was not created\"","categoryID":317,"dateInserted":"2015-04-14T19:10:16+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-16T10:49:17+00:00","insertUserID":829,"insertUser":{"userID":829,"name":"janicep","url":"https:\/\/community.smartsheet.com\/profile\/janicep","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-04-14T18:55:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":829,"lastUser":{"userID":829,"name":"janicep","url":"https:\/\/community.smartsheet.com\/profile\/janicep","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-04-14T18:55:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":12,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/113\/recurring-error-window","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/113\/recurring-error-window","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":281,"urlcode":"Support","name":"Support"}],"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":88,"type":"discussion","name":"Tip for Day to get the team to play.","excerpt":"One of the things that we have done as of late to speed the ability to work in the sheet and for people to move about in the sheet is hyperlink your sub sheets to your master sheet. The Hyperlink creates a fast way to go to anothe sheet without closing the main sheet. If you have you settings correct you can have a new tab…","categoryID":317,"dateInserted":"2015-04-07T23:06:03+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-14T12:28:21+00:00","insertUserID":333,"insertUser":{"userID":333,"name":"Jeremy Michels","url":"https:\/\/community.smartsheet.com\/profile\/Jeremy%20Michels","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/43\/ba\/n43ba1a2307110b5ba8a90560a2c0d51b.jpg","dateLastActive":"2019-02-13T17:06:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":217,"lastUser":{"userID":217,"name":"Charles DESCOTES","url":"https:\/\/community.smartsheet.com\/profile\/Charles%20DESCOTES","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/32\/3f\/n323f1116fa227f6a10234012f2d333a9.jpg","dateLastActive":"2019-06-03T04:55:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":37,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/88\/tip-for-day-to-get-the-team-to-play","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/88\/tip-for-day-to-get-the-team-to-play","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"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":104,"type":"discussion","name":"Can we add charts and metrics to create a dashboard","excerpt":"Is there a way to add charts or create real time dashboards.","categoryID":317,"dateInserted":"2015-04-13T09:52:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-14T03:35:20+00:00","insertUserID":728,"insertUser":{"userID":728,"name":"Bhuvikan Vinay Nayak","url":"https:\/\/community.smartsheet.com\/profile\/Bhuvikan%20Vinay%20Nayak","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-04-13T09:49:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":245,"lastUser":{"userID":245,"name":"JamesR","title":"","url":"https:\/\/community.smartsheet.com\/profile\/JamesR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/87\/15\/n8715b9481d6c0836c04cd6097804bec6.jpg","dateLastActive":"2019-07-19T03:25:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":44,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/104\/can-we-add-charts-and-metrics-to-create-a-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104\/can-we-add-charts-and-metrics-to-create-a-dashboard","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":215,"urlcode":"Templates","name":"Templates"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"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":55,"type":"discussion","name":"Alert for RYG's","excerpt":"One person is wanting to be notified when their RYG ball turns green, which means a document they are needing is complete. In the notifications, I can only choose for her to be notified when that column changes for anyone. Is there a formula I can do that will accomplish this? Blessings, Loann","categoryID":317,"dateInserted":"2015-03-17T16:23:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-07T12:19:00+00:00","insertUserID":254,"insertUser":{"userID":254,"name":"Loann McGee","url":"https:\/\/community.smartsheet.com\/profile\/Loann%20McGee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G3A1KBYOQBWU\/nBYWBBSSF9DWC.jpg","dateLastActive":"2023-06-09T20:30:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":254,"lastUser":{"userID":254,"name":"Loann McGee","url":"https:\/\/community.smartsheet.com\/profile\/Loann%20McGee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G3A1KBYOQBWU\/nBYWBBSSF9DWC.jpg","dateLastActive":"2023-06-09T20:30:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":75,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/55\/alert-for-rygs","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/55\/alert-for-rygs","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":209,"urlcode":"Media & Entertainment","name":"Media & Entertainment"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"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":57,"type":"discussion","name":"Love the \"Publish\" tab on Reports!","excerpt":"One question - I don't see a way to keep the attachments\/discussions private when sending via this new method, or am I missing it? I really like this new option that eliminates the need to share the page. Thanks, Smartsheet!","categoryID":317,"dateInserted":"2015-03-23T13:05:58+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-03-23T18:04:49+00:00","insertUserID":254,"insertUser":{"userID":254,"name":"Loann McGee","url":"https:\/\/community.smartsheet.com\/profile\/Loann%20McGee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G3A1KBYOQBWU\/nBYWBBSSF9DWC.jpg","dateLastActive":"2023-06-09T20:30:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":177,"lastUser":{"userID":177,"name":"Travis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Travis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/30\/n9b30d18a803dd0ccefe2f8f2d8765390.jpg","dateLastActive":"2020-01-21T20:47:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/57\/love-the-publish-tab-on-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/57\/love-the-publish-tab-on-reports","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":209,"urlcode":"Media & Entertainment","name":"Media & Entertainment"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":223,"urlcode":"Publish","name":"Publish"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":281,"urlcode":"Support","name":"Support"},{"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":49,"type":"discussion","name":"Mapping App - Refining results","excerpt":"We have a Smartsheet database of over 2700 names. Other than unchecking each name once the map starts populating, is there a way to refine the search to a particular name, state, etc?","categoryID":317,"dateInserted":"2015-03-10T14:27:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-03-12T11:47:39+00:00","insertUserID":254,"insertUser":{"userID":254,"name":"Loann McGee","url":"https:\/\/community.smartsheet.com\/profile\/Loann%20McGee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G3A1KBYOQBWU\/nBYWBBSSF9DWC.jpg","dateLastActive":"2023-06-09T20:30:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":254,"lastUser":{"userID":254,"name":"Loann McGee","url":"https:\/\/community.smartsheet.com\/profile\/Loann%20McGee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G3A1KBYOQBWU\/nBYWBBSSF9DWC.jpg","dateLastActive":"2023-06-09T20:30:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":6,"countViews":35,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/49\/mapping-app-refining-results","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49\/mapping-app-refining-results","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":209,"urlcode":"Media & Entertainment","name":"Media & Entertainment"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":281,"urlcode":"Support","name":"Support"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">