公式

TODAY(-30),…","categoryID":322,"dateInserted":"2018-04-30T17:28:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-01T18:44:47+00:00","insertUserID":1016,"insertUser":{"userID":1016,"name":"Elvin Montanez","url":"https:\/\/community.smartsheet.com\/profile\/Elvin%20Montanez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-30T17:16:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":23666,"lastUser":{"userID":23666,"name":"Chris McKay","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20McKay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-09\/d5\/d2\/nd5d2693be28ccbd24f978b00c5d1db1d.JPG","dateLastActive":"2018-08-14T22:59:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":126,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/24496\/formula-to-count-rows-in-a-date-range-across-columns-and-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/24496\/formula-to-count-rows-in-a-date-range-across-columns-and-status","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":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":271,"urlcode":"Services","name":"Services"},{"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":24526,"type":"discussion","name":"IF Formula for a sheet","excerpt":"I am trying to get this formula to work correctly. I believe I am close however it is not working correctly. I have attached a screen shot. ","categoryID":322,"dateInserted":"2018-05-01T09:56:06+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-01T11:22:46+00:00","insertUserID":46491,"insertUser":{"userID":46491,"name":"justin46491","url":"https:\/\/community.smartsheet.com\/profile\/justin46491","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-27T09:55:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":46131,"lastUser":{"userID":46131,"name":"Bryan Sampson","url":"https:\/\/community.smartsheet.com\/profile\/Bryan%20Sampson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-15T13:13:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":55,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/24526\/if-formula-for-a-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/24526\/if-formula-for-a-sheet","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-05\/9e\/e0\/9ee0adcbe918d32c8356aff9dba51d38.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Snapshot.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":219,"urlcode":"Sheets","name":"Sheets"},{"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":24361,"type":"discussion","name":"Nested IF using additional AND logical functions","excerpt":"I am struggling with creation of formula for defining tasks status (Green, Yellow, Red). Getting the UNPEARSEABLE or INCORRECT ARRANGMENT SET error messages. My formula is right now as follows: =IF(ISBLANK([RESPONSE DATE]88); \"Gray\", IF([RESPONSE DATE]88 <= [ORIGINAL DUE DATE]88; \"Green\", IF(AND([RESPONSE DATE]88 >…","categoryID":322,"dateInserted":"2018-04-26T06:44:54+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-30T11:53:21+00:00","insertUserID":46111,"insertUser":{"userID":46111,"name":"w.bawaked46111","url":"https:\/\/community.smartsheet.com\/profile\/w.bawaked46111","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-28T17:19: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\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-06-07T21:12:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":66,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/24361\/nested-if-using-additional-and-logical-functions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/24361\/nested-if-using-additional-and-logical-functions","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":218,"urlcode":"Construction","name":"Construction"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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":24441,"type":"discussion","name":"Cross-sheet \"countif\" formula with three criteria","excerpt":"I am struggling with another Countif formula. I have a working formula in one column that counts proposals filtered by month and year. I am trying to modify it to add another criteria so I can count proposals filtered by the month year that also have the sales stage of \"Asset Management Plan.\" The formula doesn't give me…","categoryID":322,"dateInserted":"2018-04-27T14:58:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-27T15:14:22+00:00","insertUserID":12177,"insertUser":{"userID":12177,"name":"Kelly Ospina","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Ospina","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xejAscrj8FY!5OjBOSryaaY!xV-7tumcaRX","dateLastActive":"2023-05-31T13:35:59+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-07T21:12:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":185,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/24441\/cross-sheet-countif-formula-with-three-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/24441\/cross-sheet-countif-formula-with-three-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":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":24421,"type":"discussion","name":"SUMIF no error, but returns '0' vs. actual sum","excerpt":"I'm using the Sum =SUM(CHILDREN()) to capture scoring of items by various teams, which is working great for each tool\/category, but I want to now show a score by team (not just overall total by tool). =SUMIF(Tool6:Tool187, \"Development\", [Key factor]6:[Key factor]187) - this results in '0' (should be 35) Summing a number…","categoryID":322,"dateInserted":"2018-04-27T10:34:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-27T11:52:27+00:00","insertUserID":42541,"insertUser":{"userID":42541,"name":"tere.pile42541","url":"https:\/\/community.smartsheet.com\/profile\/tere.pile42541","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-12T12:29:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":42541,"lastUser":{"userID":42541,"name":"tere.pile42541","url":"https:\/\/community.smartsheet.com\/profile\/tere.pile42541","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-12T12:29:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":10309,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/24421\/sumif-no-error-but-returns-0-vs-actual-sum","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/24421\/sumif-no-error-but-returns-0-vs-actual-sum","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":24411,"type":"discussion","name":"countif to total summary two different values into one","excerpt":"I have a sheet with different values I would like to sum a group of them and not in detail. Example I have values like CAR, BUS, TABLE, CHAIR I am trying to use a countif formula to sum up a total off all vehicles, like CAR and BUS. So I tried countifs(Range:range, CAR, Range:Range, BUS) however that doesnt seam to work.…","categoryID":322,"dateInserted":"2018-04-27T03:54:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-27T11:17:30+00:00","insertUserID":46271,"insertUser":{"userID":46271,"name":"Eriq","url":"https:\/\/community.smartsheet.com\/profile\/Eriq","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-01T05:14:20+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-07T21:12:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":116,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/24411\/countif-to-total-summary-two-different-values-into-one","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/24411\/countif-to-total-summary-two-different-values-into-one","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":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":24366,"type":"discussion","name":"How to concatenate two functions in a single cell","excerpt":"I want to concatenate two functions in a single cell and populate the values in the same cell separated by coma.In excel we do the same by =H65-K65 &\",\"& I65-L65 but in smartsheet when I try the same like =[Next month Proposed date for First]2 - [Assigned date of First PCT after Finetuning]2 &\",\"& [Second PCT]2-[Assigned…","categoryID":322,"dateInserted":"2018-04-26T10:43:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-26T20:14:31+00:00","insertUserID":46146,"insertUser":{"userID":46146,"name":"Soumya","url":"https:\/\/community.smartsheet.com\/profile\/Soumya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-26T10:39:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":6085,"lastUser":{"userID":6085,"name":"Admin@PAT","url":"https:\/\/community.smartsheet.com\/profile\/Admin%40PAT","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-07T00:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":129,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/24366\/how-to-concatenate-two-functions-in-a-single-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/24366\/how-to-concatenate-two-functions-in-a-single-cell","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":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":24396,"type":"discussion","name":"Need Help with a formula","excerpt":"I'm trying to convert an excel spreadsheet to a smartsheet. How would I convert this formula? =IF(SUM(AH6:AL6)=0,,AJ6+$AP6+$AS6+$AT6) Yeah, I am an extreme rookie when it comes to this stuff. ","categoryID":322,"dateInserted":"2018-04-26T17:53:27+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-26T19:26:02+00:00","insertUserID":46246,"insertUser":{"userID":46246,"name":"leahr46246","url":"https:\/\/community.smartsheet.com\/profile\/leahr46246","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-26T17:52:16+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-07T21:12:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":54,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/24396\/need-help-with-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/24396\/need-help-with-a-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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":271,"urlcode":"Services","name":"Services"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">