金融

=DATE(2018, 4, 1)) Next I'd like to add…","categoryID":322,"dateInserted":"2018-07-24T17:24:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-03-18T23:23:41+00:00","insertUserID":55506,"insertUser":{"userID":55506,"name":"jjimenez55506","url":"https:\/\/community.smartsheet.com\/profile\/jjimenez55506","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-24T17:09:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-06-23T21:28:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":60,"countViews":7738,"score":null,"hot":3211670878,"url":"https:\/\/community.smartsheet.com\/discussion\/29166\/countifs-between-dates-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/29166\/countifs-between-dates-criteria","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":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"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":25971,"type":"question","name":"Attachment in an online Form","excerpt":"Hello, I have creeated an online form but I need that people can add an attachment (image). Anyone knows if this is possible and how? I guess it is possible as this form I am filling in has this feature. Thanks you for your help Ugo Quaglino","categoryID":321,"dateInserted":"2018-05-28T14:09:18+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-03-16T16:36:47+00:00","insertUserID":49201,"insertUser":{"userID":49201,"name":"ugo.quaglino49201","url":"https:\/\/community.smartsheet.com\/profile\/ugo.quaglino49201","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-28T14:02:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":121759,"lastUser":{"userID":121759,"name":"Raven Clarke","url":"https:\/\/community.smartsheet.com\/profile\/Raven%20Clarke","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-22T02:42:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":15,"countViews":10844,"score":null,"hot":3206510165,"url":"https:\/\/community.smartsheet.com\/discussion\/25971\/attachment-in-an-online-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25971\/attachment-in-an-online-form","format":"Html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-04-08T15:21:11+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":238,"urlcode":"Finance","name":"Finance"},{"tagID":268,"urlcode":"Attachments","name":"Attachments"}],"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":65583,"type":"question","name":"Formula to check box if cell contains Date OR Text","excerpt":"I have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to time (as a date is not always applicable to this particular field). How can I revise my…","categoryID":321,"dateInserted":"2020-01-28T22:34:19+00:00","dateUpdated":null,"dateLastComment":"2023-02-16T20:22:01+00:00","insertUserID":114831,"insertUser":{"userID":114831,"name":"Melissa Shandy","url":"https:\/\/community.smartsheet.com\/profile\/Melissa%20Shandy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!kpNCvxUSffw!HaFE3_cvl_o!MSnQcMpysii","dateLastActive":"2023-04-24T19:19:46+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-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":15565,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/65583\/formula-to-check-box-if-cell-contains-date-or-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65583\/formula-to-check-box-if-cell-contains-date-or-text","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/842\/0RJLZ49L42I3.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"File Sample.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-01-29T17:55:11+00:00","dateAnswered":"2020-01-29T08:58:09+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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":51346,"type":"discussion","name":"Getting notified of undeliverable SmartSheet automated e-mails","excerpt":"Hello, Is there a way to determine which Outlook receipents of an Automated alert or update via SmartSheet were not delivered or be able to create a read receipt? Thank you, ","categoryID":321,"dateInserted":"2019-06-24T09:24:43+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-02-13T17:03:26+00:00","insertUserID":93546,"insertUser":{"userID":93546,"name":"RTWIA","url":"https:\/\/community.smartsheet.com\/profile\/RTWIA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-25T05:54:38+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-23T21:28:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":231,"score":null,"hot":3237677889,"url":"https:\/\/community.smartsheet.com\/discussion\/51346\/getting-notified-of-undeliverable-smartsheet-automated-e-mails","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/51346\/getting-notified-of-undeliverable-smartsheet-automated-e-mails","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":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":100758,"type":"question","name":"How to make Networkdays formula display less than 0 values","excerpt":"Hello, I am having multiple issues with my calculations using MAX and NETWORKDAYS. In the “Invoice Variance” field my numbers are displaying as negative numbers using the following formula =MAX(NETWORKDAYS([Invoice Submission Due Date]@row, [Original Invoice Receipt Date]@row, [Resubmitted Invoice Receipt Date]1:[2nd…","categoryID":322,"dateInserted":"2023-02-07T03:14:47+00:00","dateUpdated":"2023-02-07T07:14:06+00:00","dateLastComment":"2023-02-07T14:32:22+00:00","insertUserID":157391,"insertUser":{"userID":157391,"name":"Linda Armstrong","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Linda%20Armstrong","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3KGJ9RCBMGHB\/n9N6VKUS4IVIX.png","dateLastActive":"2023-06-23T16:33:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":157391,"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-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":150,"score":null,"hot":3351521829,"url":"https:\/\/community.smartsheet.com\/discussion\/100758\/how-to-make-networkdays-formula-display-less-than-0-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100758\/how-to-make-networkdays-formula-display-less-than-0-values","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/TTW0TAFPRT7K\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-07T14:13:19+00:00","dateAnswered":"2023-02-07T13:32:00+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":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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":100494,"type":"question","name":"Smartsheets Budget Forecasting","excerpt":"Hello, I am trying to create a custom sheet. It would be a calendar with a nested daily budget. For each day of the week we would be able to update the expenses or add budget forecasting. It should also show the running monthly and yearly total.","categoryID":321,"dateInserted":"2023-02-01T14:02:52+00:00","dateUpdated":null,"dateLastComment":"2023-02-01T17:33:25+00:00","insertUserID":157658,"insertUser":{"userID":157658,"name":"SoCo Cad","url":"https:\/\/community.smartsheet.com\/profile\/SoCo%20Cad","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJxH9ZTaJ-PIIEKj7DpWp1q26T-UWEEQAg7mPO3X=s96-c","dateLastActive":"2023-02-01T18:16:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":157658,"lastUser":{"userID":157658,"name":"SoCo Cad","url":"https:\/\/community.smartsheet.com\/profile\/SoCo%20Cad","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJxH9ZTaJ-PIIEKj7DpWp1q26T-UWEEQAg7mPO3X=s96-c","dateLastActive":"2023-02-01T18:16:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":128,"score":null,"hot":3350534177,"url":"https:\/\/community.smartsheet.com\/discussion\/100494\/smartsheets-budget-forecasting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100494\/smartsheets-budget-forecasting","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-01T17:31:59+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"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}]},{"discussionID":99920,"type":"question","name":"How do I make a Basic Cashflow Line Graph?","excerpt":"I have to think I am just missing something obvious, because I am having the most difficult time using the Dashboard to create a Line Graph that shows my cash flow over time. I tried using only two columns (again, this is a very basic chart) that has the dollar amount figure, and the date that the amount was recorded. My…","categoryID":321,"dateInserted":"2023-01-19T19:44:17+00:00","dateUpdated":"2023-01-19T19:49:04+00:00","dateLastComment":"2023-01-23T13:16:57+00:00","insertUserID":157110,"insertUser":{"userID":157110,"name":"eewald","url":"https:\/\/community.smartsheet.com\/profile\/eewald","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-06T16:27:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":76,"score":null,"hot":3348639074,"url":"https:\/\/community.smartsheet.com\/discussion\/99920\/how-do-i-make-a-basic-cashflow-line-graph","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99920\/how-do-i-make-a-basic-cashflow-line-graph","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-01-23T13:16:57+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":207,"urlcode":"Sales","name":"Sales"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}],"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":99988,"type":"question","name":"I want to populate a Quote with information from a price list sheet","excerpt":"Hi Is there a formula or functionality that would enable me to to create a quotation using data from a price list on a separate sheet ? For instance on the price list sheet Column A ( SKU \/ Stock Code ) , Column B ( Description ) , Column C ( Unit Price ) . I want to fill the SKU \/ Stock code into the quote and have the…","categoryID":322,"dateInserted":"2023-01-21T19:34:45+00:00","dateUpdated":null,"dateLastComment":"2023-01-21T22:21:52+00:00","insertUserID":157201,"insertUser":{"userID":157201,"name":"Veshlin","url":"https:\/\/community.smartsheet.com\/profile\/Veshlin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-21T19:45:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-06-23T21:28:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":87,"score":null,"hot":3348669997,"url":"https:\/\/community.smartsheet.com\/discussion\/99988\/i-want-to-populate-a-quote-with-information-from-a-price-list-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99988\/i-want-to-populate-a-quote-with-information-from-a-price-list-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-01-21T22:21:52+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":207,"urlcode":"Sales","name":"Sales"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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":98819,"type":"question","name":"Formula to add a number in a cell based on other figures","excerpt":"Hi hoping for any help I can get on this. Using the image as a reference. Im trying to make [Length score] show a number between 1-4. the scenario being if the length is 30 days or less it equals 1 and between 30-90 it would show a 2, between 90-150 show a 3 and between 150-365 show a 4. Would love any help on this people…","categoryID":322,"dateInserted":"2022-12-15T16:28:23+00:00","dateUpdated":null,"dateLastComment":"2022-12-16T18:04:49+00:00","insertUserID":156037,"insertUser":{"userID":156037,"name":"Petcheyd03","url":"https:\/\/community.smartsheet.com\/profile\/Petcheyd03","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-19T15:15:45+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-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":92,"score":null,"hot":3342339192,"url":"https:\/\/community.smartsheet.com\/discussion\/98819\/formula-to-add-a-number-in-a-cell-based-on-other-figures","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98819\/formula-to-add-a-number-in-a-cell-based-on-other-figures","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-16T08:18:57+00:00","dateAnswered":"2022-12-15T20:52:06+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":238,"urlcode":"Finance","name":"Finance"},{"tagID":241,"urlcode":"Calendar","name":"Calendar 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":98026,"type":"question","name":"Removing Total Row from Smartsheet Reports","excerpt":"I am creating several reports that subtotal financial information by various groups (i.e. revenue, numerous expense categories, EBIT etc.). I do not want the reports to display a total row that sums all the revenue, expenses, and profit as this is misleading. Does the functionality exist to turn this off?","categoryID":321,"dateInserted":"2022-11-22T00:47:40+00:00","dateUpdated":"2022-11-22T09:24:09+00:00","dateLastComment":"2022-11-22T12:09:03+00:00","insertUserID":31411,"insertUser":{"userID":31411,"name":"Matthew Murray","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20Murray","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T03:52:15+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-06-23T21:28:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":317,"score":1,"hot":3338197903,"url":"https:\/\/community.smartsheet.com\/discussion\/98026\/removing-total-row-from-smartsheet-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98026\/removing-total-row-from-smartsheet-reports","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-11-22T12:09:03+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":238,"urlcode":"Finance","name":"Finance"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}">