探索。问。回答

\"","excerpt":"I am trying to make this work. I want the formula to count all the store numbers except for the ones where the Contract Status is not equal to several options in the Contract Status column. Not sure where I am going wrong. =COUNTIFS({Circle K Summary Data Store #}, {Circle K Summary Data Contract Status}, <>\"Submitted to…","categoryID":322,"dateInserted":"2022-09-22T19:13:49+00:00","dateUpdated":null,"dateLastComment":"2022-10-03T21:39:01+00:00","insertUserID":149961,"insertUser":{"userID":149961,"name":"french2s","title":"","url":"https:\/\/community.smartsheet.com\/profile\/french2s","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-04T14:26:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":149961,"lastUser":{"userID":149961,"name":"french2s","title":"","url":"https:\/\/community.smartsheet.com\/profile\/french2s","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-04T14:26:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":55,"score":null,"hot":3328710770,"url":"https:\/\/community.smartsheet.com\/discussion\/95816\/set-up-countifs-with-muliple","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95816\/set-up-countifs-with-muliple","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-04T08:19:26+00:00","dateAnswered":"2022-09-22T20:00:59+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":95938,"type":"question","name":"Why has my metric sheet stopped working?","excerpt":"The following table counts data from a sheet using COUNTIFS functions. EG countif it a question and = the row or countif its an alternative proposal and the row. However the its stooped counting. For example there are 5 'Role specific' questions in the sheet but the table below shows 3? And there is one Alt. prp but none…","categoryID":322,"dateInserted":"2022-09-27T10:13:03+00:00","dateUpdated":null,"dateLastComment":"2022-10-03T21:24:37+00:00","insertUserID":112016,"insertUser":{"userID":112016,"name":"Phil Wightman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Phil%20Wightman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/35\/2e\/n352e0e53bf6c86b6f26b8d2be7cf0153.JPG","dateLastActive":"2022-10-17T21:10:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":112016,"lastUser":{"userID":112016,"name":"Phil Wightman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Phil%20Wightman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/35\/2e\/n352e0e53bf6c86b6f26b8d2be7cf0153.JPG","dateLastActive":"2022-10-17T21:10:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":47,"score":null,"hot":3329107660,"url":"https:\/\/community.smartsheet.com\/discussion\/95938\/why-has-my-metric-sheet-stopped-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95938\/why-has-my-metric-sheet-stopped-working","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/IPK0H2KTAOJC\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-02T15:34: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":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"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":96122,"type":"question","name":"Converting text to Date to populate Gant & Calendar App.","excerpt":"I have an Allocation sheet where I need the user to choose the month in the \"Month\" column and the 'Start' populates with the first date of the month and the \"End\" populates with the last date of the month so I can have a start and finish date to show the resource and Allocation on a Gant and Calendar app. I have tried to…","categoryID":322,"dateInserted":"2022-09-30T23:34:19+00:00","dateUpdated":null,"dateLastComment":"2022-10-03T21:09:22+00:00","insertUserID":150221,"insertUser":{"userID":150221,"name":"kaia2001","url":"https:\/\/community.smartsheet.com\/profile\/kaia2001","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!4UdruPPCUTs!xci0Me7RNSQ!1lY0HVwwYYU","dateLastActive":"2022-10-18T19:53:52+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-10-22T09:46:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":42,"score":null,"hot":3329415821,"url":"https:\/\/community.smartsheet.com\/discussion\/96122\/converting-text-to-date-to-populate-gant-calendar-app","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96122\/converting-text-to-date-to-populate-gant-calendar-app","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/LMSMHOZSR9TF\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-03T20:19:45+00:00","dateAnswered":"2022-10-01T00:54:23+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":439,"urlcode":"gantt-view","name":"Gantt View"},{"tagID":449,"urlcode":"calendar-app","name":"Calendar App"}],"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}">