Finance

\"0\", [% complete]1 <= \"0.25\"), \"Quarter\", IF(OR([% complete]1 > \"0.25\", [% complete]1 <= \"0.5\"), \"Half\", IF(OR([% complete]1 >…","categoryID":322,"dateInserted":"2019-11-01T10:48:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-01T17:14:58+00:00","insertUserID":109661,"insertUser":{"userID":109661,"name":"Alessandro Terranova","url":"https:\/\/community.smartsheet.com\/profile\/Alessandro%20Terranova","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-18T09:32:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-06-23T22:29:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":131,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/61756\/if-or-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/61756\/if-or-formula-help","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":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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":61516,"type":"discussion","name":"Linking Reports in different sheets","excerpt":"hi guys background: I work for an investment management company. Internally we have about 6 different reports that are interlinked in this manner Report 1: the starting point is an events or presentation calender Report 2: the actual presentation report, where feedback is gathered from presentations that come from the…","categoryID":321,"dateInserted":"2019-10-30T01:44:29+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-30T07:56:53+00:00","insertUserID":109371,"insertUser":{"userID":109371,"name":"Vuyi","url":"https:\/\/community.smartsheet.com\/profile\/Vuyi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-30T01:30:56+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-30T17:11:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":71,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/61516\/linking-reports-in-different-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/61516\/linking-reports-in-different-sheets","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":238,"urlcode":"Finance","name":"Finance"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"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":60371,"type":"discussion","name":"Applying new template sheet to old projects","excerpt":"We have a collection of projects that were created some time ago. Since the projects were created, the blueprint those projects were based on have had some additional template sheets added. Is there a way to incorporate those new template sheets into the old projects, either on a single project by project basis or in bulk…","categoryID":321,"dateInserted":"2019-10-16T12:28:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-29T10:45:13+00:00","insertUserID":107806,"insertUser":{"userID":107806,"name":"Doug L","url":"https:\/\/community.smartsheet.com\/profile\/Doug%20L","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-16T12:23:25+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":251,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/60371\/applying-new-template-sheet-to-old-projects","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/60371\/applying-new-template-sheet-to-old-projects","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"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":60266,"type":"question","name":"import and consolidate daily changed excel file with SS sheet","excerpt":"Hi, currently my team (4 members) uses one excel file to save information about insurance incidents (task tracking with regularly action documentation f.e. what have craftsmen done, has insurance paid a.s.o). It takes a few month until we all may use SmartSheet. Until that time I would like to daily or weekly import the…","categoryID":321,"dateInserted":"2019-10-15T10:03:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-28T08:24:35+00:00","insertUserID":107466,"insertUser":{"userID":107466,"name":"Joerg Schmidt","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Joerg%20Schmidt","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZFNXGZNkaTw!pKDXaa84r-Y!9WSWmAUhJKN","dateLastActive":"2023-05-04T06:23:52+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-30T17:11:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":221,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/60266\/import-and-consolidate-daily-changed-excel-file-with-ss-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/60266\/import-and-consolidate-daily-changed-excel-file-with-ss-sheet","format":"Html","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-26T10:16:37+00:00","dateAnswered":"2019-10-15T10:15:41+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":220,"urlcode":"Hospitality","name":"Hospitality"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"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":61296,"type":"discussion","name":"Card View by Contact List column type","excerpt":"Hi there, I have a sheet for tracking contracts and assign the contracts to my staff of 10. I would like to be able to have my swim lanes be organized\/sorted by the \"Contact List\" column type (I have my assigned staff in this column). based on this help…","categoryID":321,"dateInserted":"2019-10-26T00:25:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-26T06:08:59+00:00","insertUserID":92216,"insertUser":{"userID":92216,"name":"Waseem K","url":"https:\/\/community.smartsheet.com\/profile\/Waseem%20K","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-06\/41\/20\/n41205f53724ed064a509a697256a11a5.jpg","dateLastActive":"2021-10-07T16:26:04+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-30T17:11:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":874,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/61296\/card-view-by-contact-list-column-type","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/61296\/card-view-by-contact-list-column-type","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":238,"urlcode":"Finance","name":"Finance"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":444,"urlcode":"card-view","name":"Card View"}],"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":60741,"type":"discussion","name":"DAYS360 Formula","excerpt":"I'm trying to move various spreadsheets from Excel to Smartsheet but I keep needing the DAYS360 formula. It is very common to calculate loans based on 360 day years so monthly figures remain constant (at 30 days\/mo). I was very surprised to see that this formula is not supported by Smartsheet. Is there a way to mimic it?…","categoryID":322,"dateInserted":"2019-10-18T16:28:40+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-21T11:05:46+00:00","insertUserID":102366,"insertUser":{"userID":102366,"name":"jeffdimock","url":"https:\/\/community.smartsheet.com\/profile\/jeffdimock","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-18T16:22:59+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":201,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/60741\/days360-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/60741\/days360-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":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"}],"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}">