公式

=10000,([Total Billed]40)<20000),([GP Amount]40*5%, IF(AND(([Total Billed]40)>=20000,([Total Billed]40)<30000),([GP Amount]40*10%, IF(AND(([Total…","categoryID":317,"dateInserted":"2015-08-18T12:04:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-08-18T14:27:48+00:00","insertUserID":3102,"insertUser":{"userID":3102,"name":"Hugh Robinson","url":"https:\/\/community.smartsheet.com\/profile\/Hugh%20Robinson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-16T11:55:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":3102,"lastUser":{"userID":3102,"name":"Hugh Robinson","url":"https:\/\/community.smartsheet.com\/profile\/Hugh%20Robinson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-16T11:55:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":8,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/1913\/if-and-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/1913\/if-and-formula-help","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"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":1904,"type":"discussion","name":"Formula Help with NA","excerpt":"I need help with a formula. I have 3 date columns. If there's a date in datecol1, and a date in datecol2, and either a date or NA in datecol3, then enter 1 in col 4. I am not a programmer, but can usually figure it out. Not this time! This is what is in col 4 cell, but I get Unparseable. =IF(ISDATE([datecol1]7),…","categoryID":317,"dateInserted":"2015-08-17T14:24:55+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-08-18T12:45:33+00:00","insertUserID":2201,"insertUser":{"userID":2201,"name":"Janet757","url":"https:\/\/community.smartsheet.com\/profile\/Janet757","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-02-06T13:17:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":177,"lastUser":{"userID":177,"name":"Travis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Travis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/30\/n9b30d18a803dd0ccefe2f8f2d8765390.jpg","dateLastActive":"2020-01-21T20:47:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":3,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/1904\/formula-help-with-na","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/1904\/formula-help-with-na","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"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":1888,"type":"discussion","name":"Auto Date updating a published report of Events List","excerpt":"We have an a Smartsheet of Events - tradeshows etc that we will be participating in. While initially developed for internal sharing, I have added a \"publish\" checkmark column, with those items checked being part of a Report, which I then Publish to our public website. I would like to include a formula in the checkmark…","categoryID":317,"dateInserted":"2015-08-14T15:26:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-08-17T17:54:24+00:00","insertUserID":1350,"insertUser":{"userID":1350,"name":"Bob Payton","url":"https:\/\/community.smartsheet.com\/profile\/Bob%20Payton","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-04-06T16:18:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":177,"lastUser":{"userID":177,"name":"Travis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Travis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/30\/n9b30d18a803dd0ccefe2f8f2d8765390.jpg","dateLastActive":"2020-01-21T20:47:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":4,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/1888\/auto-date-updating-a-published-report-of-events-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/1888\/auto-date-updating-a-published-report-of-events-list","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":223,"urlcode":"Publish","name":"Publish"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"}],"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":285,"type":"discussion","name":"One Click Task Completion","excerpt":"Hi All, In Project we invariably have different variants of: - percent complete - Task Status - Completion Date - etc What I am looking for is a way where say I tick a \"Complete\" checkbox and: - percent complete goes to 100% - Task status goes to complete - completion date is today - etc ","categoryID":317,"dateInserted":"2015-05-11T19:00:20+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-08-17T17:26:34+00:00","insertUserID":1799,"insertUser":{"userID":1799,"name":"Geoff Kennedy","url":"https:\/\/community.smartsheet.com\/profile\/Geoff%20Kennedy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-09-12T02:50:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":1799,"lastUser":{"userID":1799,"name":"Geoff Kennedy","url":"https:\/\/community.smartsheet.com\/profile\/Geoff%20Kennedy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-09-12T02:50:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":1974,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/285\/one-click-task-completion","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/285\/one-click-task-completion","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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":1891,"type":"discussion","name":"The Power of the SUMIFS Function","excerpt":"When I discovered the SUMIFS statement recently it solved a problem that had made me keep things like the project timesheets for our company in a very rigid format that basically listed all projects and functions (types of work) that could be charged to. I had wanted to let people select the project they were working on…","categoryID":317,"dateInserted":"2015-08-14T16:40:54+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-08-17T14:49:28+00:00","insertUserID":459,"insertUser":{"userID":459,"name":"Jim Hook","url":"https:\/\/community.smartsheet.com\/profile\/Jim%20Hook","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9d\/28\/n9d28abcc5c5c53d330f96b33667ff30d.png","dateLastActive":"2022-08-19T17:24:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":185,"lastUser":{"userID":185,"name":"Greg Hawk","url":"https:\/\/community.smartsheet.com\/profile\/Greg%20Hawk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-04-10T19:46:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/1891\/the-power-of-the-sumifs-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/1891\/the-power-of-the-sumifs-function","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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":1876,"type":"discussion","name":"Calculations in a report","excerpt":"I'm trying to create a report where i only see records with End Date = this week. (so not 'the coming 7 days' or something, only this week#) I have column 'Week# that shows the week# of the field 'End Date' in my sheet =ROUND((([End Date]1 - DATE(2015, 1, 1)) \/ 7) + 0.49, 0) in my report I defined in the 'What' part:…","categoryID":317,"dateInserted":"2015-08-13T04:03:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-08-13T15:16:58+00:00","insertUserID":2714,"insertUser":{"userID":2714,"name":"Rob van Dijk","url":"https:\/\/community.smartsheet.com\/profile\/Rob%20van%20Dijk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-07-14T05:22:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":391,"lastUser":{"userID":391,"name":"John Sauber","title":"","url":"https:\/\/community.smartsheet.com\/profile\/John%20Sauber","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/18\/38\/n18381cdb6f38bc6b446fd26a96bafc25.jpg","dateLastActive":"2023-06-05T14:59:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":136,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/1876\/calculations-in-a-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/1876\/calculations-in-a-report","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"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":1145,"type":"discussion","name":"Bug in latest version of SmartSheet","excerpt":"Hello Smartsheet Community, I use the formula : =[Previous Week]1 - [End Date]1 to show me my variance each week when I status my smartsheet schedule. The latested update in Smartsheet broke my formula so that when I copy the \"End Date\" field into the \"Previous Week\" field it no longer shows as \"0\" when th dates haven't…","categoryID":317,"dateInserted":"2015-07-15T15:44:14+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-08-12T16:01:23+00:00","insertUserID":2524,"insertUser":{"userID":2524,"name":"LPiccini","url":"https:\/\/community.smartsheet.com\/profile\/LPiccini","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-08-12T15:59:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":2524,"lastUser":{"userID":2524,"name":"LPiccini","url":"https:\/\/community.smartsheet.com\/profile\/LPiccini","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-08-12T15:59:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":29,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/1145\/bug-in-latest-version-of-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/1145\/bug-in-latest-version-of-smartsheet","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"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":1842,"type":"discussion","name":"Counting Number of Times a Predecessor is Used","excerpt":"Hi, Long story behind this one, I'll try to keep it short. On Smartsheet, the critical path tool isn't working for my sheet because our project has too many hard deadlines and we are not using enough predecessors; however, we need to be able to view a critical path, so I have accepted that I will have to create one…","categoryID":317,"dateInserted":"2015-08-10T17:39:05+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-08-11T17:43:27+00:00","insertUserID":2703,"insertUser":{"userID":2703,"name":"Kelci Peterson","url":"https:\/\/community.smartsheet.com\/profile\/Kelci%20Peterson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-01-04T15:20:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":190,"lastUser":{"userID":190,"name":"Allie","url":"https:\/\/community.smartsheet.com\/profile\/Allie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-09-22T18:33:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":139,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/1842\/counting-number-of-times-a-predecessor-is-used","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/1842\/counting-number-of-times-a-predecessor-is-used","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt 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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">