Finance

0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue?? Please see attached excel with formula in Column D Thank you in advance :) ","categoryID":322,"dateInserted":"2019-02-05T06:19:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-04-23T11:00:36+00:00","insertUserID":41351,"insertUser":{"userID":41351,"name":"Anna Mullins","url":"https:\/\/community.smartsheet.com\/profile\/Anna%20Mullins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-03\/c6\/0e\/nc60eae9be62b12eb53439135e60f2271.PNG","dateLastActive":"2019-02-05T15:25:51+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-06-28T01:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":370,"score":null,"hot":12,"url":"https:\/\/community.smartsheet.com\/discussion\/40586\/formula-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40586\/formula-not-working","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/ee\/fb\/eefb428415c3eeb9aaf289881d0445e1.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"formula.JPG"},"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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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":58286,"type":"discussion","name":"=SUMIF Month-to-Month","excerpt":"I am trying to create a graph for a Dashboard that will display the total amount of approved $$ within each month and total amount of denied $$ within each month. I will also need a rolling YTD total. So far this is what I have for the formula: =SUMIFS({RSA Form Range 2}, {RSA Form Range 9}, \"Green\", {RSA Form Range 3},…","categoryID":322,"dateInserted":"2019-09-23T14:40:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-04-21T20:01:58+00:00","insertUserID":103696,"insertUser":{"userID":103696,"name":"aalang103696","url":"https:\/\/community.smartsheet.com\/profile\/aalang103696","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p_lDKTUw3jw!xYDCsU0h8tQ!PJ51JKHy0GN","dateLastActive":"2023-04-05T14:23:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-27T19:56:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":1444,"score":null,"hot":11,"url":"https:\/\/community.smartsheet.com\/discussion\/58286\/sumif-month-to-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/58286\/sumif-month-to-month","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-09\/31\/9c\/319cac465f7ab492abe6fdd599493687.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture5.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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":67502,"type":"question","name":"Calculating a minimum payment figure using a formula or function","excerpt":"Hello, I'm hoping someone may be able to help me with something that probably seems quite obvious or basic however, my knowledge on formulas or functions within Smartsheet is not advanced, so I apologise in advance! I'm trying to get my finances in order and thought I'd use Smartsheet to plan this. I've done a screen shot…","categoryID":322,"dateInserted":"2020-04-16T17:35:51+00:00","dateUpdated":null,"dateLastComment":"2020-04-20T13:04:16+00:00","insertUserID":78206,"insertUser":{"userID":78206,"name":"SteCoxy","url":"https:\/\/community.smartsheet.com\/profile\/SteCoxy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!aTDbGqngcGQ!2wnbf5m83zw!VTDReGCjYpc","dateLastActive":"2023-04-20T13:57:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-27T19:56:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":162,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/67502\/calculating-a-minimum-payment-figure-using-a-formula-or-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67502\/calculating-a-minimum-payment-figure-using-a-formula-or-function","format":"rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/389\/RH1Z6ACBINTN.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2020-04-16 18.31.57.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-04-17T20:17:46+00:00","dateAnswered":"2020-04-17T11:53:28+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":26976,"type":"discussion","name":"Plotting cost over time","excerpt":"Hi- I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week. I am easily able to plot cost for items that begin or end in a calendar month, but not for items that span months. I am pretty sure each cost would need to be broken down into…","categoryID":322,"dateInserted":"2018-06-14T13:02:58+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-04-16T21:23:55+00:00","insertUserID":11374,"insertUser":{"userID":11374,"name":"Mike Liggett","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Liggett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-06-14T12:57:35+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-06-28T01:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":924,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/26976\/plotting-cost-over-time","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26976\/plotting-cost-over-time","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-06\/44\/f6\/44f67b77c0bf7aee344a1fe3386ca83e.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2018-06-14 at 9.56.42 AM.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"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":67481,"type":"discussion","name":"Local Government Uses","excerpt":"I am a Mayor of the city in Washington. We are looking at Smartsheet to add as a project management tool for staff. I am interested in how other local governments are using Smartsheet? Specific areas of interest are Capital Projects, Human Resources (Performance Reviews?), Permit Tracking, and Finance. Brett","categoryID":321,"dateInserted":"2020-04-15T22:56:42+00:00","dateUpdated":null,"dateLastComment":"2020-04-15T22:56:42+00:00","insertUserID":120482,"insertUser":{"userID":120482,"name":"Brett Gailey","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brett%20Gailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/072\/nKK5PKQTPSKBM.png","dateLastActive":"2020-07-02T20:24:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":120482,"lastUser":{"userID":120482,"name":"Brett Gailey","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brett%20Gailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/072\/nKK5PKQTPSKBM.png","dateLastActive":"2020-07-02T20:24:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":168,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/67481\/local-government-uses","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67481\/local-government-uses","format":"rich","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":238,"urlcode":"Finance","name":"Finance"},{"tagID":263,"urlcode":"Government","name":"Government"}],"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":58901,"type":"discussion","name":"Access Security for Forms","excerpt":"Does anyone know if there's a way to limit form access to a specific person or group of people. Or, is there something in the works at Smartsheet to address this? Looks like there is currently two options. * Anyone * Anyone with a Smartsheet login I use Smartsheet forms to submit project tasks (not too confidential) and…","categoryID":321,"dateInserted":"2019-09-30T11:30:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-04-15T16:35:46+00:00","insertUserID":73391,"insertUser":{"userID":73391,"name":"aaron.fye73391","url":"https:\/\/community.smartsheet.com\/profile\/aaron.fye73391","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AAuE7mDwPz6HMMsO1ckpOv3Fq6cT-E8d8L1kbl1H0w9vaQ","dateLastActive":"2020-02-09T04:04:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":31361,"lastUser":{"userID":31361,"name":"Lushenkm","url":"https:\/\/community.smartsheet.com\/profile\/Lushenkm","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-03\/28\/23\/n2823264853dab78e3928fcedb8963179.png","dateLastActive":"2020-04-23T18:03:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":1236,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/58901\/access-security-for-forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/58901\/access-security-for-forms","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":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":273,"urlcode":"Security","name":"Security"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":67256,"type":"question","name":"Adding resources cost","excerpt":"Hi all, I'm fairly new to smartsheet, and i wanted to know how do i use the \"bill rate\", ca I change it? How can I access it? I think this is the solution for my issue which is i want to add the costs to my resources and I couldn't find the best practices for that. Would love to hear any tips and recommendation. Thanks,…","categoryID":321,"dateInserted":"2020-04-08T16:59:15+00:00","dateUpdated":null,"dateLastComment":"2020-04-12T19:36:21+00:00","insertUserID":120325,"insertUser":{"userID":120325,"name":"Noga Ginzburg","url":"https:\/\/community.smartsheet.com\/profile\/Noga%20Ginzburg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-04-12T20:16:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":73566,"lastUser":{"userID":73566,"name":"rgochee","url":"https:\/\/community.smartsheet.com\/profile\/rgochee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-04-13T16:11:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":641,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/67256\/adding-resources-cost","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67256\/adding-resources-cost","format":"rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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"}],"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}">