公式

0, [Request Status]:[Request Status], NOT(CONTAINS(\"Cancelled\", @cell), NOT(CONTAINS(\"Merged\", @cell), NOT(CONTAINS(\"Rejected - Insufficient Value\", @cell), NOT(CONTAINS(\"Rejected - Duplicate\", @cell)), [Planned MVP Launch Date]:[Planned…","categoryID":322,"dateInserted":"2023-02-08T20:15:09+00:00","dateUpdated":null,"dateLastComment":"2023-02-08T21:03:05+00:00","insertUserID":156193,"insertUser":{"userID":156193,"name":"Anthony Favara","url":"https:\/\/community.smartsheet.com\/profile\/Anthony%20Favara","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!xWEqcSIvKno!HK9qH3ZDj3o!ZR_uQmwlGNc","dateLastActive":"2023-02-15T14:28:23+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-02-14T16:23:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":null,"hot":3351778094,"url":"https:\/\/community.smartsheet.com\/discussion\/100880\/how-do-i-count-2023-q1-items-that-are-not-specific-request-statuses","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100880\/how-do-i-count-2023-q1-items-that-are-not-specific-request-statuses","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-08T21:03:05+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":335,"urlcode":"sheet-summary","name":"Sheet Summary"}],"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":100823,"type":"question","name":"INDEX, DISTINCT, and MATCH formulas","excerpt":"I am trying to put together a list of our project managers and which business units each of them are responsible for. I need it to be in a certain format because right next to each of the business units, I am going to have 3 COUNTIFS formulas to count different things based on the project manager and business unit. I…","categoryID":322,"dateInserted":"2023-02-07T22:45:44+00:00","dateUpdated":null,"dateLastComment":"2023-02-08T20:54:40+00:00","insertUserID":147967,"insertUser":{"userID":147967,"name":"WilliamPaschall","url":"https:\/\/community.smartsheet.com\/profile\/WilliamPaschall","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ofHYKF0Gjv0!3-dZ_9Xa_j0!vXdT5UjXT2h","dateLastActive":"2023-02-15T20:03:25+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-02-14T16:23:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":36,"score":null,"hot":3351702024,"url":"https:\/\/community.smartsheet.com\/discussion\/100823\/index-distinct-and-match-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100823\/index-distinct-and-match-formulas","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/TMC7U5R1WBT8\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-08T19:07:01+00:00","dateAnswered":"2023-02-08T19:06:56+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"}],"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":100871,"type":"question","name":"Collect and display associated numbers","excerpt":"Hello, I'm looking for a formula to use to reference another sheet and collect and display the different User Story numbers associated with and OMNI #. I was thinking maybe VLOOKUP or INDEX with COLLECT or MATCH but I can't get it to work. Here is the data set: So if the formula works correctly, the row with OMNI002800…","categoryID":322,"dateInserted":"2023-02-08T18:44:23+00:00","dateUpdated":null,"dateLastComment":"2023-02-08T20:52:35+00:00","insertUserID":144713,"insertUser":{"userID":144713,"name":"Dakota Haeffner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Dakota%20Haeffner","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-9EoN6cCJXs!7Dcqe8-aSLs!vmL02Fkj5JV","dateLastActive":"2023-02-16T02:47:14+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-02-14T16:23:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":33,"score":null,"hot":3351773218,"url":"https:\/\/community.smartsheet.com\/discussion\/100871\/collect-and-display-associated-numbers","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100871\/collect-and-display-associated-numbers","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/DWO22IL82E7P\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-08T18:51:16+00:00","dateAnswered":"2023-02-08T18:46:48+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"}],"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":100795,"type":"question","name":"Formula to lookup prior cell values","excerpt":"...and not require use of the API*. Often, people want to create Smartsheets that use or track values of cells in a(nother) sheet over time, or look up a prior value using a date, or a date formula. The VLOOKUP function could be enhanced to do this, taking a date argument. Or, a separate function created to be used in…","categoryID":321,"dateInserted":"2023-02-07T16:54:01+00:00","dateUpdated":"2023-02-08T11:34:39+00:00","dateLastComment":"2023-02-08T19:41:40+00:00","insertUserID":120886,"insertUser":{"userID":120886,"name":"Peter Spung","url":"https:\/\/community.smartsheet.com\/profile\/Peter%20Spung","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xglWMfcR9zo!pVvVqTsCqjw!gmUWnxACQOg","dateLastActive":"2023-02-08T19:38:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":120886,"lastUser":{"userID":120886,"name":"Peter Spung","url":"https:\/\/community.smartsheet.com\/profile\/Peter%20Spung","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xglWMfcR9zo!pVvVqTsCqjw!gmUWnxACQOg","dateLastActive":"2023-02-08T19:38:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":44,"score":1,"hot":3351676841,"url":"https:\/\/community.smartsheet.com\/discussion\/100795\/formula-to-lookup-prior-cell-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100795\/formula-to-lookup-prior-cell-values","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-07T17:31:01+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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}],"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":100829,"type":"question","name":"Sheet Summary not matching actual with multiple criteria","excerpt":"Hello, I am new to smartsheet formulas and have a problem that needs to be solved. I am trying to capture a count of sites that have 2 criteria. Completed in one column and counting if the dropdown is \"Full Install\" \"Pre Cabled UPS Only\" and \"Revisit\". On my sheet summary, I get a total of 14 using the below formula but my…","categoryID":322,"dateInserted":"2023-02-07T23:42:55+00:00","dateUpdated":"2023-02-07T23:54:51+00:00","dateLastComment":"2023-02-08T18:00:31+00:00","insertUserID":156582,"insertUser":{"userID":156582,"name":"Andrew Taglauer","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20Taglauer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-15T22:14:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":156582,"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-02-14T16:23:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":34,"score":null,"hot":3351695606,"url":"https:\/\/community.smartsheet.com\/discussion\/100829\/sheet-summary-not-matching-actual-with-multiple-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100829\/sheet-summary-not-matching-actual-with-multiple-criteria","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-08T17:02:41+00:00","dateAnswered":"2023-02-08T16:38:31+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"}],"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":100834,"type":"question","name":"Why am I receiving #INVALID OPERATION error in some of my sheets","excerpt":"I have multiple sheets with the same columns (Health, Task Name, Start, Finish). Note that the Health column is a symbol (red, yellow, green, blue). In my summary sheet, I am using the following Index Match formula to search for Task A in Task Name column and spit out Health. =INDEX(Health:Health, MATCH(\"Task A\", [Task…","categoryID":322,"dateInserted":"2023-02-08T00:42:26+00:00","dateUpdated":null,"dateLastComment":"2023-02-08T17:21:48+00:00","insertUserID":145200,"insertUser":{"userID":145200,"name":"Omid","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Omid","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-08T19:01:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":145200,"lastUser":{"userID":145200,"name":"Omid","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Omid","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-08T19:01:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":31,"score":null,"hot":3351695654,"url":"https:\/\/community.smartsheet.com\/discussion\/100834\/why-am-i-receiving-invalid-operation-error-in-some-of-my-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100834\/why-am-i-receiving-invalid-operation-error-in-some-of-my-sheets","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-08T09:48:55+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":335,"urlcode":"sheet-summary","name":"Sheet Summary"}],"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":100589,"type":"question","name":"Trying to index match a formula for multiple sheets","excerpt":"What's wrong with this formula? =IFERROR(INDEX({Master Pipeline Name}, MATCH([Store #]@row, {Master Pipeline Store #}, 0), INDEX({Pipeline- OPEN Stores Name}, MATCH([Store #]@row, {Pipeline- OPEN Stores #}, 0) \"\")","categoryID":322,"dateInserted":"2023-02-02T18:24:45+00:00","dateUpdated":null,"dateLastComment":"2023-02-08T14:43:34+00:00","insertUserID":145530,"insertUser":{"userID":145530,"name":"Max Ahmed","url":"https:\/\/community.smartsheet.com\/profile\/Max%20Ahmed","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-14T16:31:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":145530,"lastUser":{"userID":145530,"name":"Max Ahmed","url":"https:\/\/community.smartsheet.com\/profile\/Max%20Ahmed","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-14T16:31:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":47,"score":null,"hot":3351232699,"url":"https:\/\/community.smartsheet.com\/discussion\/100589\/trying-to-index-match-a-formula-for-multiple-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100589\/trying-to-index-match-a-formula-for-multiple-sheets","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-08T14:42:42+00:00","dateAnswered":"2023-02-08T14:35:13+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"}],"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":91248,"type":"question","name":"Numerical \"Priority\" Method","excerpt":"Hello, I am in need of a method for assigning priority of a submitted row 1-10. If 1 is selected, the previous 1 needs to become a 2, the 2 becomes a 3, etc. The column needs to recalculate when a row is complete and the 'priority' column becomes blank. I don't think this would be possible without using many columns to…","categoryID":322,"dateInserted":"2022-05-18T12:50:52+00:00","dateUpdated":null,"dateLastComment":"2023-02-08T14:25:08+00:00","insertUserID":144772,"insertUser":{"userID":144772,"name":"Jess Bowles","url":"https:\/\/community.smartsheet.com\/profile\/Jess%20Bowles","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-08T14:23:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":144772,"lastUser":{"userID":144772,"name":"Jess Bowles","url":"https:\/\/community.smartsheet.com\/profile\/Jess%20Bowles","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-08T14:23:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":129,"score":null,"hot":3328748160,"url":"https:\/\/community.smartsheet.com\/discussion\/91248\/numerical-priority-method","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91248\/numerical-priority-method","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-05-18T14:03:25+00:00","dateAnswered":"2022-05-18T13:45:39+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">