公式和函数

= DATE(2020, 1, 1)), <= DATE(2020, 1, 31), [Content type]:[Content…","categoryID":322,"dateInserted":"2019-12-05T02:55:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-12-05T06:46:35+00:00","insertUserID":113396,"insertUser":{"userID":113396,"name":"Kate_","url":"https:\/\/community.smartsheet.com\/profile\/Kate_","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-12\/63\/6c\/n636cb45084ea9bd3406ab528a0fdaa7f.PNG","dateLastActive":"2022-04-20T13:31:58+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-10-20T19:53:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":113,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/64496\/countifs-with-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64496\/countifs-with-dates","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-12\/e6\/84\/e684830c5890fc4029bb51e3a8676dbb.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"formulaehelp.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":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":244,"urlcode":"Product Development","name":"Product Development"},{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"}],"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":58811,"type":"discussion","name":"Centrally Manage Drop Down Lists for Multiple Sheets","excerpt":"I work with a small Real Estate company and we lean heavily on Smartsheet for all of our task and workflow management. We have built a system of task lists, workflows, and meeting agendas that all work very well, but at the moment we have to edit drop-down lists manually sheet-by-sheet. I've searched the community for ways…","categoryID":322,"dateInserted":"2019-09-27T16:13:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-12-04T18:29:53+00:00","insertUserID":93426,"insertUser":{"userID":93426,"name":"Chann403","url":"https:\/\/community.smartsheet.com\/profile\/Chann403","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-27T16:01:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":113361,"lastUser":{"userID":113361,"name":"IT_DEPT_TRANSARC","title":"","url":"https:\/\/community.smartsheet.com\/profile\/IT_DEPT_TRANSARC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-02-03T21:48:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":849,"score":2,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/58811\/centrally-manage-drop-down-lists-for-multiple-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/58811\/centrally-manage-drop-down-lists-for-multiple-sheets","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"API Developers","name":"API and Developers"},{"tagID":230,"urlcode":"Groups and Group Management","name":"Groups and Group Management"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"}],"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":59221,"type":"discussion","name":"Difference between dates","excerpt":"Hello I am looking to pull some data from a quote log we have made up. What I need to know is what quotes were late submitting by 1-2 days and which were late submitting by 2+ days, so two data points. Attached is a screenshot of the columns we have. Requested due date is when our customer expected the quote and the date…","categoryID":322,"dateInserted":"2019-10-03T12:57:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-12-04T15:12:03+00:00","insertUserID":100661,"insertUser":{"userID":100661,"name":"NLegresley","url":"https:\/\/community.smartsheet.com\/profile\/NLegresley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-05-15T20:45:26+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-10-20T19:53:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":19,"countViews":1433,"score":null,"hot":19,"url":"https:\/\/community.smartsheet.com\/discussion\/59221\/difference-between-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59221\/difference-between-dates","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-10\/ef\/3e\/ef3ec6d46ee76915b5737ee27581b357.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Dates.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":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":64406,"type":"discussion","name":"Putting a formula in with a form submission.","excerpt":"We are trying to set up a form where you enter scores base on criteria that populates a form. Based on that data each new line of data from the form needs to have the average score of those 6 criterias. However we can't pre-fill each row with the Average formula we want as the form always drops the data in the row below…","categoryID":322,"dateInserted":"2019-12-04T11:10:26+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-12-04T12:29:31+00:00","insertUserID":113251,"insertUser":{"userID":113251,"name":"Graham Rimell","url":"https:\/\/community.smartsheet.com\/profile\/Graham%20Rimell","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!phHXaR85t_4!pQNXKZdkrro!I0_JXjc_J5c","dateLastActive":"2022-03-16T07:34:37+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\/518\/n0UL39EAWX965.jpg","dateLastActive":"2022-10-19T19:26:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":851,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/64406\/putting-a-formula-in-with-a-form-submission","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64406\/putting-a-formula-in-with-a-form-submission","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":204,"urlcode":"Forms","name":"Forms"},{"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":64236,"type":"discussion","name":"Forcing duration and start date to a specific value on Gantt","excerpt":"Dear Community, Is it possible to set a formula so that the Start Date always equals the End Date and that the Duration is always '0'? We are tracking key milestones and are only provided the End Date. I'd like to reduce the manual entry to automatically make the Start Date match the End Date and ensure that the Duration…","categoryID":322,"dateInserted":"2019-12-02T13:56:08+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-12-04T11:52:12+00:00","insertUserID":68056,"insertUser":{"userID":68056,"name":"ilene_healy68056","url":"https:\/\/community.smartsheet.com\/profile\/ilene_healy68056","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-07-13T13:43:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":68056,"lastUser":{"userID":68056,"name":"ilene_healy68056","url":"https:\/\/community.smartsheet.com\/profile\/ilene_healy68056","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-07-13T13:43:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":65,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/64236\/forcing-duration-and-start-date-to-a-specific-value-on-gantt","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64236\/forcing-duration-and-start-date-to-a-specific-value-on-gantt","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":269,"urlcode":"Gantt View","name":"Gantt View"}],"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":64381,"type":"discussion","name":"Returning a YES value","excerpt":"Trying to get a formula to evaluate 2 columns and if the 1st column is CURRENT and the 2nd Column is CHECKED, return a value of YES, and if either column doesn't show the CURRENT of CHECKED, return a value of NO. Have tried many combos and think I'm close - what's missing or wrong here: =IF(AND([Ins Status]@row =…","categoryID":322,"dateInserted":"2019-12-04T09:14:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-12-04T10:14:58+00:00","insertUserID":66561,"insertUser":{"userID":66561,"name":"Debbie Petersen","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Petersen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-12T19:51:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":66561,"lastUser":{"userID":66561,"name":"Debbie Petersen","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Petersen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-12T19:51:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":154,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/64381\/returning-a-yes-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64381\/returning-a-yes-value","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-12\/4b\/39\/4b39d97993073bc42e3d998289baad23.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.JPG"},"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"}],"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