Finance

\" & i have build this formula in excel and its working fine, but i am getting error in smartsheet…","categoryID":322,"dateInserted":"2019-09-27T04:41:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-28T05:09:33+00:00","insertUserID":84161,"insertUser":{"userID":84161,"name":"SBash","url":"https:\/\/community.smartsheet.com\/profile\/SBash","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-17T11:10:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-16T22:27:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":83,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/58731\/formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/58731\/formula","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"},{"tagID":271,"urlcode":"Services","name":"Services"},{"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":58786,"type":"discussion","name":"Comments - Keep important ones on top","excerpt":"Hello, Are we able to lock comments on rows or sheets do that they stay to the top?","categoryID":321,"dateInserted":"2019-09-27T11:32:11+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-27T13:08:25+00:00","insertUserID":105561,"insertUser":{"userID":105561,"name":"nmazardw","url":"https:\/\/community.smartsheet.com\/profile\/nmazardw","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-05-26T13:27:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-16T22:27:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":63,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/58786\/comments-keep-important-ones-on-top","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/58786\/comments-keep-important-ones-on-top","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":208,"urlcode":"Workspaces","name":"Workspaces"},{"tagID":214,"urlcode":"Search","name":"Search"},{"tagID":215,"urlcode":"Templates","name":"Templates"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"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":58696,"type":"discussion","name":"Filtering\/Slicing in Dashbaords","excerpt":"Hello SmartSheets Team, I am a little new to SmartSheets, but I have successfully built a dashboard with all the data I would like. However, I can't seem to find any functionality that allows me to filter\/slice the data in the dashboard view, say to specific users or anything like that (for example, I can see total sales…","categoryID":321,"dateInserted":"2019-09-26T18:10:46+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-27T04:00:01+00:00","insertUserID":105486,"insertUser":{"userID":105486,"name":"Matt_K84","url":"https:\/\/community.smartsheet.com\/profile\/Matt_K84","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-26T18:04:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-16T22:27:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1207,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/58696\/filtering-slicing-in-dashbaords","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/58696\/filtering-slicing-in-dashbaords","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":207,"urlcode":"Sales","name":"Sales"},{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"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":58381,"type":"discussion","name":"PayPal integration samples","excerpt":"Hi All, Does anyone knows any place where I could find any samples of how PayPal can be integrated into Smartsheet? TIA","categoryID":343,"dateInserted":"2019-09-24T03:57:03+00:00","dateUpdated":"2022-06-14T14:36:35+00:00","dateLastComment":"2019-09-26T07:24:10+00:00","insertUserID":102756,"insertUser":{"userID":102756,"name":"SmartWave","url":"https:\/\/community.smartsheet.com\/profile\/SmartWave","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-09\/85\/14\/n85143c81f9bb1187adc7e555b3b2ee92.png","dateLastActive":"2019-09-30T04:58:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-16T22:27:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":307,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/58381\/paypal-integration-samples","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/58381\/paypal-integration-samples","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":238,"urlcode":"Finance","name":"Finance"},{"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":58541,"type":"discussion","name":"Row Locking Now Requires Paid User","excerpt":"For the past 3 years I have had free license users managing a sheet and locking rows. Seems as of yesterday they lost the ability to lock rows and the annotation states that they need to upgrade to a paid user in order to do so. Can someone confirm this is the new normal? Maybe provide a link to a announcement that states…","categoryID":321,"dateInserted":"2019-09-25T09:23:25+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-25T14:31:40+00:00","insertUserID":8279,"insertUser":{"userID":8279,"name":"Shawn R","url":"https:\/\/community.smartsheet.com\/profile\/Shawn%20R","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-25T09:19:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":6388,"lastUser":{"userID":6388,"name":"Gwyneth C","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Gwyneth%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/76\/d9\/n76d9186b3bda2b96a96e61f72e8c9a49.jpg","dateLastActive":"2022-05-19T16:40:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":81,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/58541\/row-locking-now-requires-paid-user","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/58541\/row-locking-now-requires-paid-user","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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">