Finance

07.01.2019, [Completed in days]:[Completed in days]) The Smartsheet returns me the value 0 that is wrong cause I have lots of numbers that meet this criterion. Please advise and thanks in advance ","categoryID":322,"dateInserted":"2019-11-26T07:25:32+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-26T08:07:33+00:00","insertUserID":112551,"insertUser":{"userID":112551,"name":"Pilarmonia","url":"https:\/\/community.smartsheet.com\/profile\/Pilarmonia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/0b\/79\/n0b792dcb9885070d8990b9071b6b5c1a.jpg","dateLastActive":"2019-11-26T07:18:35+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-28T13:21:59+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\/63861\/dates-in-formula-averageif","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/63861\/dates-in-formula-averageif","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":216,"urlcode":"Non-profit","name":"Non-profit"},{"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":63321,"type":"discussion","name":"Formula Creation l Conditional Formatting (Automating the Process)","excerpt":"Hi! I am attempting to generate a formula to mimic the one I created using conditional formatting (essentially, I would like to automate the conditional formatting trigger). Here's how I would like the sheet to work. Based on the \"Risk Classification\" drop down selected, I would like the sheet to pre-fill the \"Periodic…","categoryID":322,"dateInserted":"2019-11-19T13:22:09+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-25T15:07:58+00:00","insertUserID":111796,"insertUser":{"userID":111796,"name":"Wydrikus","url":"https:\/\/community.smartsheet.com\/profile\/Wydrikus","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-01-14T14:10:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":111796,"lastUser":{"userID":111796,"name":"Wydrikus","url":"https:\/\/community.smartsheet.com\/profile\/Wydrikus","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-01-14T14:10:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":138,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/63321\/formula-creation-l-conditional-formatting-automating-the-process","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/63321\/formula-creation-l-conditional-formatting-automating-the-process","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-11\/09\/56\/095602febc477abf39d1a71709bdf91b.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Conditional Formatting Conditions.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":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":63541,"type":"discussion","name":"Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master View","excerpt":"Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be training in any product line. The individual product lines are listed in the primary…","categoryID":322,"dateInserted":"2019-11-21T02:31:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-25T10:29:57+00:00","insertUserID":108886,"insertUser":{"userID":108886,"name":"cyndi_walker108886","url":"https:\/\/community.smartsheet.com\/profile\/cyndi_walker108886","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/76\/d4\/n76d497ef96ee057f6ff64eac637263b2.jpg","dateLastActive":"2020-08-27T22:52:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":45236,"lastUser":{"userID":45236,"name":"Alejandra","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Alejandra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-04\/8a\/fe\/n8afeceb592ad5845f46c7d931defba07.JPG","dateLastActive":"2020-05-15T18:56:51+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":354,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/63541\/track-daily-variance-between-forecast-to-actuals-across-multiple-cells-and-sheets-into-master-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/63541\/track-daily-variance-between-forecast-to-actuals-across-multiple-cells-and-sheets-into-master-view","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-11\/08\/97\/0897617f7be53c86c3fbffcd27c87e90.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Forecasted Sheet Sample.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":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":281,"urlcode":"Support","name":"Support"},{"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":54221,"type":"discussion","name":"Workflow or Alarm","excerpt":"Hello all, I work in company established in Germany. So my english writing can confuse you. I am new here and want to ask a question regarding the workflow \/ alarm tool. The automated mails are linked to a formular or the receiver gets a link to the complete Project. Is it possible to link the alarm to a DashBoard? This is…","categoryID":321,"dateInserted":"2019-08-02T03:51:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-25T08:02:16+00:00","insertUserID":98571,"insertUser":{"userID":98571,"name":"u.brinkrode98571","url":"https:\/\/community.smartsheet.com\/profile\/u.brinkrode98571","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BCjbweweKCY!XPDan2gmBuQ!xktUe96Crcc","dateLastActive":"2022-05-19T11:49:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":98571,"lastUser":{"userID":98571,"name":"u.brinkrode98571","url":"https:\/\/community.smartsheet.com\/profile\/u.brinkrode98571","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BCjbweweKCY!XPDan2gmBuQ!xktUe96Crcc","dateLastActive":"2022-05-19T11:49:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":85,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/54221\/workflow-or-alarm","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/54221\/workflow-or-alarm","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":238,"urlcode":"Finance","name":"Finance"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"}],"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":62836,"type":"discussion","name":"IF AND Function For Reporting","excerpt":"Hi guys, I am trying setting up a new report for my team which will allow them to bring through project activities based on the following criteria: * The week the activity happened in is before today's current week. * The RYG status is red OR green OR yellow I am using a column set up as a checkbox and trying to put an IF(…","categoryID":322,"dateInserted":"2019-11-14T05:37:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-19T04:50:22+00:00","insertUserID":111236,"insertUser":{"userID":111236,"name":"Marcus","url":"https:\/\/community.smartsheet.com\/profile\/Marcus","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-18T08:07:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":111236,"lastUser":{"userID":111236,"name":"Marcus","url":"https:\/\/community.smartsheet.com\/profile\/Marcus","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-18T08:07:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":258,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/62836\/if-and-function-for-reporting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62836\/if-and-function-for-reporting","format":"Html","groupID":null,"statusID":0,"image":{"url":"\/libraries\/smiley\/images\/regular_smile.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"smiley"},"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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"}],"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":62636,"type":"discussion","name":"The new prices have stopped FREE USERs to SEND line of a Sheet","excerpt":"The new policy has change the rules, Free Users are no more able to send line of a Sheet . There are some Workspaces where you can ten or more free user who need that to share. And 120€\/users is to expansive now to do it. I send 2 requests to Smartsheet. Support Case Number: 03599177 Support Case Number: 03595187 but no…","categoryID":321,"dateInserted":"2019-11-12T14:15:19+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-15T07:28:48+00:00","insertUserID":110921,"insertUser":{"userID":110921,"name":"Tristan RAMAGET","url":"https:\/\/community.smartsheet.com\/profile\/Tristan%20RAMAGET","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-15T06:11:41+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-28T10:28:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":107,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/62636\/the-new-prices-have-stopped-free-users-to-send-line-of-a-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62636\/the-new-prices-have-stopped-free-users-to-send-line-of-a-sheet","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">