公式

50, (MILEAGE6 - 50) * [MILEAGE EXPENSE]$2) I want values between 0 and 50 to return a blank and not a 0. When I do the above, it messes up the total column because it thinks the…","categoryID":317,"dateInserted":"2015-04-29T16:47:46+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-29T20:26:49+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":190,"lastUser":{"userID":190,"name":"Allie","url":"https:\/\/community.smartsheet.com\/profile\/Allie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-09-22T18:33:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":739,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/202\/can-you-return-a-blank-cell-in-a-formula-that-isnt-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/202\/can-you-return-a-blank-cell-in-a-formula-that-isnt-text","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":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":195,"type":"discussion","name":"Formulas not following over","excerpt":"When I input a claim from the web form, it appears somewhat down in my sheet, and no formulas. This is also the case when I have a row with formulas, then I move it to another sheet with the same columns and formulas, but it appears in the subsequent sheet in the bottom row, but no formulas. This is very frustrating…","categoryID":317,"dateInserted":"2015-04-28T14:40:59+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-29T16:12:48+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":1183,"lastUser":{"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":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":293,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/195\/formulas-not-following-over","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/195\/formulas-not-following-over","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":147,"type":"discussion","name":"Feature Request: Rank order macro","excerpt":"We recently migrated from a google doc to smartsheet for tracking a project portfolio. Google docs offered the ability to apply a Rank Order macro to let us sort the list based on a calcuated priority score for each project in the list. Here is an example of the macro: =rank(AQ3,AQ:AQ) Smartsheets lets us score projects…","categoryID":317,"dateInserted":"2015-04-22T12:16:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-28T15:33:11+00:00","insertUserID":1062,"insertUser":{"userID":1062,"name":"Haig Assadourian","url":"https:\/\/community.smartsheet.com\/profile\/Haig%20Assadourian","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-06-20T13:09:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":333,"lastUser":{"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":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":6,"countViews":188,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/147\/feature-request-rank-order-macro","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/147\/feature-request-rank-order-macro","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":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"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":181,"type":"discussion","name":"Money format in cell not working","excerpt":"I am using this formula to output a fee based on gross loss for insurance claim. The resulting total column shows proper dollar format when it is over $100,000 based on first IF statement. When it is either of the following IF statements, ie for losses > 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":278,"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":156,"type":"discussion","name":"Active Reports","excerpt":"Has anyone out there been able to achieve this? What I would call an Active Report is as follows. A visually formatted report page that is interactive with a master sheet. The report sheet would be formatted to display a ascetically pleasing presentation of data select from the master sheet by selecting a row. This could…","categoryID":317,"dateInserted":"2015-04-23T04:21:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-23T12:03:03+00:00","insertUserID":1132,"insertUser":{"userID":1132,"name":"Gary Webster","url":"https:\/\/community.smartsheet.com\/profile\/Gary%20Webster","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-04-23T04:07:32+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":46,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/156\/active-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/156\/active-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":207,"urlcode":"Sales","name":"Sales"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"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":123,"type":"discussion","name":"Update Requests Limited?","excerpt":"I am sending update requests for a sheet that has initial items filled in by formulas - dates, as well as \"Yes\/No\" dropdown selections. This makes it easy for the person who starts with this template to put in suggested initial dates, then ask for exact dates from these directly involved. In the sheet the editor can…","categoryID":317,"dateInserted":"2015-04-17T13:49:06+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-20T09:51:19+00:00","insertUserID":859,"insertUser":{"userID":859,"name":"Brian Dowler","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20Dowler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-04-20T09:48:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":859,"lastUser":{"userID":859,"name":"Brian Dowler","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20Dowler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-04-20T09:48:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/123\/update-requests-limited","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/123\/update-requests-limited","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"}],"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}">