公式

0.01, [List Price]221:[List Price]90) , but it only works if there are numbers. Any help would be appreciated! ","categoryID":322,"dateInserted":"2018-06-02T14:51:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-03T18:37:22+00:00","insertUserID":49986,"insertUser":{"userID":49986,"name":"tedf","url":"https:\/\/community.smartsheet.com\/profile\/tedf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-06-02T14:48:22+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":49986,"lastUser":{"userID":49986,"name":"tedf","url":"https:\/\/community.smartsheet.com\/profile\/tedf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-06-02T14:48:22+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":529,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/26371\/sum-if-there-is-any-text-in-a-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26371\/sum-if-there-is-any-text-in-a-range","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":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":7431,"type":"discussion","name":"Compare two dates and apply conditional formatting","excerpt":"I have two columns of forecasted dates UTILITY and IN SERVICE. When the UTILITY date is past the IN SERVICE date I want both cells hilighted. For example if UTILITY = 9\/30\/17 and IN SERVICE = 5\/10\/17, I want both cells to be red. I understand That I'll have to use a third column to base the formatting from but I cannot get…","categoryID":319,"dateInserted":"2017-02-24T13:12:04+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-01T17:17:48+00:00","insertUserID":10746,"insertUser":{"userID":10746,"name":"Faith Glass-Wilson","url":"https:\/\/community.smartsheet.com\/profile\/Faith%20Glass-Wilson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-08T19:23:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":32656,"lastUser":{"userID":32656,"name":"MattRuggles","url":"https:\/\/community.smartsheet.com\/profile\/MattRuggles","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-06\/b0\/6e\/nb06e20effff431c1f22a6e05a83e7b3a.jpg","dateLastActive":"2019-06-04T17:56:40+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":1700,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/7431\/compare-two-dates-and-apply-conditional-formatting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7431\/compare-two-dates-and-apply-conditional-formatting","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":213,"urlcode":"Conditional Formatting","name":"Conditional Formatting"},{"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":26266,"type":"discussion","name":"How to total quantity based on similar name in column","excerpt":"I am trying to total points based on the persons name. Basically one column has the names, some of them duplicates. Another Column has points. I need a third column for total points at the end that looks at the names, finds those that are the same and totals the points for that person in the total points column. I have…","categoryID":322,"dateInserted":"2018-05-31T20:05:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-01T17:01:04+00:00","insertUserID":49811,"insertUser":{"userID":49811,"name":"shaun49811","url":"https:\/\/community.smartsheet.com\/profile\/shaun49811","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-17T00:45:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":49941,"lastUser":{"userID":49941,"name":"emilyr","url":"https:\/\/community.smartsheet.com\/profile\/emilyr","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-08T17:18:06+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":680,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/26266\/how-to-total-quantity-based-on-similar-name-in-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26266\/how-to-total-quantity-based-on-similar-name-in-column","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-05\/7a\/f6\/7af6ac8704b73553f6e8e5513e0c06a2.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.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":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":213,"urlcode":"Conditional Formatting","name":"Conditional Formatting"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":278,"urlcode":"Importing and Exporting","name":"Importing and Exporting"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"}],"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":26211,"type":"discussion","name":"Mark child if Parent meets criteria","excerpt":"Hi- I see lots of threads to mark a parent if a child meets a certain criteria, but I am looking for the opposite. I have Material, Labor, and Subcontractor Parent rows and would like to mark the children with either a number or letter indicating if it is a child of one of those parents (Material =1, Labor =2,…","categoryID":322,"dateInserted":"2018-05-31T12:29:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-01T14:57:16+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":11374,"lastUser":{"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":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":94,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/26211\/mark-child-if-parent-meets-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26211\/mark-child-if-parent-meets-criteria","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":207,"urlcode":"Sales","name":"Sales"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"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":22766,"type":"discussion","name":"Sum of Parents","excerpt":"I keep track of pending transactions in a real estate office, and have each month as a parent and the closings scheduled as children under the correct month. On the parent row of each month I've got totals showing for the children. This all works great. What I can't figure out is how to total the parents. At the bottom of…","categoryID":322,"dateInserted":"2018-04-04T14:13:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-01T12:07:53+00:00","insertUserID":43436,"insertUser":{"userID":43436,"name":"jenwillcockson","url":"https:\/\/community.smartsheet.com\/profile\/jenwillcockson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/158\/n62WCIKWISAFV.jpg","dateLastActive":"2020-03-06T18:01:15+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\/518\/n0UL39EAWX965.jpg","dateLastActive":"2023-01-27T19:01:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":2669,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/22766\/sum-of-parents","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/22766\/sum-of-parents","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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"}],"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":26271,"type":"discussion","name":"Stop Counting NETWORKDAY after Done Box is checked","excerpt":"Hi everyone, I'm hoping this is easy to read, it is hard to explain. I am trying to STOP counting days from commencement date of a project once the DONE box is checked. I have managed to make it work without using NETWORKDAY, using this formula =IF(Done1 = 1, [Last Updated]1 - [Commencement Date]1, TODAY() - [Commencement…","categoryID":322,"dateInserted":"2018-05-31T21:22:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-01T10:29:38+00:00","insertUserID":49831,"insertUser":{"userID":49831,"name":"adrian","url":"https:\/\/community.smartsheet.com\/profile\/adrian","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-31T21:18:00+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-01-27T22:10:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":81,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/26271\/stop-counting-networkday-after-done-box-is-checked","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26271\/stop-counting-networkday-after-done-box-is-checked","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":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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">