公式

0))","categoryID":322,"dateInserted":"2023-06-07T01:39:34+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T02:11:15+00:00","insertUserID":162138,"insertUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T02:26:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":122388,"lastUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-06-07T21:01:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":49,"score":null,"hot":3372208249,"url":"https:\/\/community.smartsheet.com\/discussion\/106113\/how-to-count-how-many-times-a-cell-is-in-a-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106113\/how-to-count-how-many-times-a-cell-is-in-a-column","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XP9S1XCLFZD6\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T01:53:43+00:00","dateAnswered":"2023-06-07T01:44:04+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":106108,"type":"question","name":"Can someone help me with a date formula?","excerpt":"I have a column that shows how many days have passed since a start date. I would like to add a column with an end date, and if there is an end date, have that count stop. So if the end date is blank, the count will keep going up. If the end date is entered, it will show how many days passed between the start date and the…","categoryID":322,"dateInserted":"2023-06-06T21:37:53+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T01:12:29+00:00","insertUserID":162131,"insertUser":{"userID":162131,"name":"Matt_at_Loves","title":"Need Help with Date Formula","url":"https:\/\/community.smartsheet.com\/profile\/Matt_at_Loves","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/O9FF6EDB81ZI\/nBO2FKGZ8E7EQ.jpg","dateLastActive":"2023-06-07T01:44:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-08T02:27:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":34,"score":null,"hot":3372188422,"url":"https:\/\/community.smartsheet.com\/discussion\/106108\/can-someone-help-me-with-a-date-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106108\/can-someone-help-me-with-a-date-formula","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T01:12:29+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":105882,"type":"question","name":"CountIf Day is between Start and Due Date","excerpt":"I'm stumped in this formula... I wish to perform a countif when a date is between two dates. I have a Start Date and a Due Date Column and in another sheet I have a list of days. and I want to count how many times the day June 07th is between Start Date and Due Date In the case below June 07th should be counted as 1, June…","categoryID":322,"dateInserted":"2023-06-01T13:18:13+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T22:24:56+00:00","insertUserID":160591,"insertUser":{"userID":160591,"name":"Ana Guilherme","url":"https:\/\/community.smartsheet.com\/profile\/Ana%20Guilherme","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!zmDQs0zV1dU!n9jSn-jh_6c!w8cSL36s2dl","dateLastActive":"2023-06-06T22:21:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":160591,"lastUser":{"userID":160591,"name":"Ana Guilherme","url":"https:\/\/community.smartsheet.com\/profile\/Ana%20Guilherme","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!zmDQs0zV1dU!n9jSn-jh_6c!w8cSL36s2dl","dateLastActive":"2023-06-06T22:21:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":53,"score":null,"hot":3371718189,"url":"https:\/\/community.smartsheet.com\/discussion\/105882\/countif-day-is-between-start-and-due-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105882\/countif-day-is-between-start-and-due-date","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/920PBZQ5P07Y\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-01T14:02:10+00:00","dateAnswered":"2023-06-01T13:35:06+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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">