Finance

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":771,"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":148,"type":"discussion","name":"Printing of Web Forms","excerpt":"Hello, The Maryland State Department of Education would like to transition the Notice of Grant Award process from manual entry to collecting requests via a Smartsheets web form. A requirement of this process would be to recieve signature and initialed approvals on a paper printout of the form after it has past through each…","categoryID":317,"dateInserted":"2015-04-22T12:43:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-23T17:38:57+00:00","insertUserID":1056,"insertUser":{"userID":1056,"name":"Maria Hallums","url":"https:\/\/community.smartsheet.com\/profile\/Maria%20Hallums","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-04-22T11:53:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":230,"lastUser":{"userID":230,"name":"David Smith","url":"https:\/\/community.smartsheet.com\/profile\/David%20Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/1a\/12\/n1a12bb8ad01cb8fa24b5ec3482c6156a.jpg","dateLastActive":"2020-11-12T18:36:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":993,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/148\/printing-of-web-forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/148\/printing-of-web-forms","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":223,"urlcode":"publish","name":"Publish"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":250,"urlcode":"printing","name":"Printing"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":277,"urlcode":"integrations","name":"Integrations"}],"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":"2023-07-18T19:55:31+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":44,"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":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"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User 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}">