公式与函数

\"Close\",\"Open\" If $Status4 = \"Close\" the formula returns a value. However, if $Status4 is not equal to \"Close\" I want the formula to return \"Open\". I get the following response #UNPARAEABLE The formula does work if I only…","categoryID":322,"dateInserted":"2020-05-04T20:23:02+00:00","dateUpdated":null,"dateLastComment":"2020-05-05T11:50:25+00:00","insertUserID":94821,"insertUser":{"userID":94821,"name":"1996mustang","url":"https:\/\/community.smartsheet.com\/profile\/1996mustang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-10T18:44:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":94821,"lastUser":{"userID":94821,"name":"1996mustang","url":"https:\/\/community.smartsheet.com\/profile\/1996mustang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-10T18:44:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":37,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/68024\/formula-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68024\/formula-not-working","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-05-05T11:50:09+00:00","dateAnswered":"2020-05-04T20:37:32+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":[],"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":68026,"type":"discussion","name":"Formula to count values that are not struck through","excerpt":"I have a sheet with a conditional format set up to strike through the row when the finish date is reached. I am creating a sheet summary where I would like to add up the days (in the duration column) for each project. What is the formula I should be using? How do I set a conditional format as my criterion in a SUMIF…","categoryID":322,"dateInserted":"2020-05-04T20:49:21+00:00","dateUpdated":null,"dateLastComment":"2020-05-05T08:30:48+00:00","insertUserID":117528,"insertUser":{"userID":117528,"name":"Sidonia Posteuca","url":"https:\/\/community.smartsheet.com\/profile\/Sidonia%20Posteuca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-29T22:06:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-12-14T18:08:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":98,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/68026\/formula-to-count-values-that-are-not-struck-through","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68026\/formula-to-count-values-that-are-not-struck-through","format":"rich","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":[],"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":68027,"type":"discussion","name":"Autofill Contacts in a New Row","excerpt":"When creating a new row in my sheet, I want \"Column A\" to autofill the contact from the cell above it. \"Column A\" is always the same contact for the purposes of some reports and other sheets. If I can't autofill a new row's cell with the contact from above, is there a way to create a formula that always enters the same…","categoryID":322,"dateInserted":"2020-05-04T21:26:53+00:00","dateUpdated":null,"dateLastComment":"2020-05-05T07:32:21+00:00","insertUserID":37006,"insertUser":{"userID":37006,"name":"cody","url":"https:\/\/community.smartsheet.com\/profile\/cody","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-07-27T15:19:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-12-14T18:08:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":69,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/68027\/autofill-contacts-in-a-new-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68027\/autofill-contacts-in-a-new-row","format":"rich","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":[],"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":68023,"type":"question","name":"Adding FY based on a date","excerpt":"Hello! So, our FY runs from 7\/1 through 6\/30 and based on Loss Date, I want it to add the FY for FY14 through 20 as that is the data set. I used this formula though currently it is #UNPARSABLE. What am I doing wrong? =IF(AND([“Loss Date”] DATE(2013, 7, 1), [“Loss Date”] <= DATE(2014, 6, 30)), \"FY14\", IF(AND([“Loss Date”]…","categoryID":322,"dateInserted":"2020-05-04T20:21:07+00:00","dateUpdated":null,"dateLastComment":"2020-05-04T21:20:22+00:00","insertUserID":11066,"insertUser":{"userID":11066,"name":"Chris Hallo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Hallo","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zEjYc4xZyTY!nCPbnzgtiHw!3apta-6OY7C","dateLastActive":"2022-10-17T19:40:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-12T22:36:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":37,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/68023\/adding-fy-based-on-a-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68023\/adding-fy-based-on-a-date","format":"rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/812\/4NKR908LWMV3.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":67905,"type":"question","name":"Auto-status, 'Up Next' criteria overlap","excerpt":"Hello! I am working on a sheet with Start\/Finish dates and need to populate status' into the following 4 categories: not started, in progress, complete, up next For not started\/in progress\/complete i have the following formula working: =IF(AND([Start Date]@row < TODAY(), [Finish Date]@row < TODAY()), \"Complete\", IF([Start…","categoryID":322,"dateInserted":"2020-04-30T12:45:59+00:00","dateUpdated":"2020-04-30T13:46:41+00:00","dateLastComment":"2020-05-04T19:51:28+00:00","insertUserID":121072,"insertUser":{"userID":121072,"name":"Emma Schachter","url":"https:\/\/community.smartsheet.com\/profile\/Emma%20Schachter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-05-04T17:54:46+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":"2022-12-14T13:18:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":66,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/67905\/auto-status-up-next-criteria-overlap","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67905\/auto-status-up-next-criteria-overlap","format":"rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"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":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":320,"urlcode":"department","name":"department"}],"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":67933,"type":"question","name":"How to convert Date (MM\/DD\/YYYY) into Month and Quarters and Year such as \"Q1 2020\" and \"Jan 2020\"","excerpt":"How to convert Date (MM\/DD\/YYYY) into Month and Quarters and Year such as \"Q1 2020\" and \"Jan 2020\"","categoryID":322,"dateInserted":"2020-04-30T18:14:48+00:00","dateUpdated":null,"dateLastComment":"2020-05-04T17:47:52+00:00","insertUserID":120885,"insertUser":{"userID":120885,"name":"Anil Rattan","url":"https:\/\/community.smartsheet.com\/profile\/Anil%20Rattan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-22T13:31:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":120885,"lastUser":{"userID":120885,"name":"Anil Rattan","url":"https:\/\/community.smartsheet.com\/profile\/Anil%20Rattan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-22T13:31:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":311,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/67933\/how-to-convert-date-mm-dd-yyyy-into-month-and-quarters-and-year-such-as-q1-2020-and-jan-2020","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67933\/how-to-convert-date-mm-dd-yyyy-into-month-and-quarters-and-year-such-as-q1-2020-and-jan-2020","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-05-06T10:06:00+00:00","dateAnswered":"2020-05-04T17:47: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":[],"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":67698,"type":"question","name":"I need help with a formula, I need it to return a blank cell.","excerpt":"I have the following 2 formulas: =IF([Rental Period]3 = \"Daily\", VLOOKUP([Scissor Lifts]3, {Scissor Rates 2}, 2, false), IF([Rental Period]3 = \"Weekly\", VLOOKUP([Scissor Lifts]3, {Scissor Rates 2}, 3, false), IF([Rental Period]3 = \"Monthly\", VLOOKUP([Scissor Lifts]3, {Scissor Rates 2}, 4, false), \"//www.santa-greenland.com/community/categories/formulas-and-functions/\"))) =IF([Rental Period]1…","categoryID":322,"dateInserted":"2020-04-23T14:40:38+00:00","dateUpdated":null,"dateLastComment":"2020-05-04T17:15:29+00:00","insertUserID":120850,"insertUser":{"userID":120850,"name":"Cindy Bowker","url":"https:\/\/community.smartsheet.com\/profile\/Cindy%20Bowker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-04-06T18:50:12+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":"2022-12-14T13:18:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":44,"countViews":464,"score":null,"hot":44,"url":"https:\/\/community.smartsheet.com\/discussion\/67698\/i-need-help-with-a-formula-i-need-it-to-return-a-blank-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67698\/i-need-help-with-a-formula-i-need-it-to-return-a-blank-cell","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-04-23T20:51:15+00:00","dateAnswered":"2020-04-23T20:43:24+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":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":67974,"type":"question","name":"Countifs #INCORRECT ARGUMENT SET","excerpt":"Hello, I'm trying to get the following countifs function to work but I'm getting the Incorrect Argument Set error: =COUNTIFS([Employee Name]:[Employee Name], \"Name\", Sunday:Saturday, \"W\") For context I'm trying to count the number of days specific employees have worked YTD.","categoryID":322,"dateInserted":"2020-05-01T19:24:04+00:00","dateUpdated":"2020-05-01T19:41:56+00:00","dateLastComment":"2020-05-04T17:08:17+00:00","insertUserID":121139,"insertUser":{"userID":121139,"name":"Desmond Kispert-Bostick","url":"https:\/\/community.smartsheet.com\/profile\/Desmond%20Kispert-Bostick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-05-29T20:14:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":121139,"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":"2022-12-14T13:18:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":13,"countViews":385,"score":null,"hot":13,"url":"https:\/\/community.smartsheet.com\/discussion\/67974\/countifs-incorrect-argument-set","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67974\/countifs-incorrect-argument-set","format":"rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"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":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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

帮助文章资源欧宝体育app官方888