公式

= March 1, 2017\". Can I use a formula for this? I tried to use \"=Today()\" but that says \"Invalid Date\" (with or without the quotes). Is this possible?","categoryID":319,"dateInserted":"2017-04-20T11:21:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-22T09:57:15+00:00","insertUserID":11555,"insertUser":{"userID":11555,"name":"Bill Peck","url":"https:\/\/community.smartsheet.com\/profile\/Bill%20Peck","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-07-26T06:53:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":75686,"lastUser":{"userID":75686,"name":"joecross98","url":"https:\/\/community.smartsheet.com\/profile\/joecross98","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-28T06:11:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":835,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/8376\/can-i-filter-with-a-date-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/8376\/can-i-filter-with-a-date-formula","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"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":39471,"type":"discussion","name":"Time with fractional seconds","excerpt":"Good morning, I am using Smartsheet to track swim time which has a format of minutes:seconds:fractionalseconds (i.e. 5:00.50). I would like to see if anyone has a solution for a couple of issues I am seeing: 1. I would like to use the MIN function to look across multiple cells (swim meets) and pull the minimum for the…","categoryID":322,"dateInserted":"2019-01-20T10:20:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-22T08:21:35+00:00","insertUserID":75776,"insertUser":{"userID":75776,"name":"ryan.shaver75776","url":"https:\/\/community.smartsheet.com\/profile\/ryan.shaver75776","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-20T10:16:05+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-06-09T14:12:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":65,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/39471\/time-with-fractional-seconds","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/39471\/time-with-fractional-seconds","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":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"tagID":391,"urlcode":"product-development","name":"Product Development"}],"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":39221,"type":"discussion","name":"Rollup text to parent based on MAX of another column *SOLVED","excerpt":"Hello- This is a look up of sorts. I have a list of files. Each time i receive the file it is logged with it's package name and date. I can MAX CHILDREN the date and it rolls up to the PARENT, however, I cannot figure out how to have the package name of the max date rollup. Any assistance is appreciated! ","categoryID":322,"dateInserted":"2019-01-16T17:32:38+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-22T07:39:50+00:00","insertUserID":74151,"insertUser":{"userID":74151,"name":"lext","url":"https:\/\/community.smartsheet.com\/profile\/lext","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-21T13:58:04+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-06-09T14:12:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":82,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/39221\/rollup-text-to-parent-based-on-max-of-another-column-solved","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/39221\/rollup-text-to-parent-based-on-max-of-another-column-solved","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-01\/b4\/9b\/b49b66deb5782e22c91d3f27ddba180f.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2019-01-16_14-28-46.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"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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":21936,"type":"discussion","name":"Checkbox question","excerpt":"Is there a way to have a checkbox automatically checked if other columns with checkboxes get checked? I have 4 columns with checkboxes and instead of doing value columns for each one I would like to do a summary checkbox and just value one column. If that's not possible, can you set values for more than one column?","categoryID":322,"dateInserted":"2018-03-22T16:31:06+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-21T16:10:32+00:00","insertUserID":41471,"insertUser":{"userID":41471,"name":"tcanelli41471","url":"https:\/\/community.smartsheet.com\/profile\/tcanelli41471","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zWdcs1Rjyjo!mQjd3shRMVQ!Gy9EFhE1S-j","dateLastActive":"2021-05-04T13:44:04+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\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-06-08T15:18:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":206,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/21936\/checkbox-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/21936\/checkbox-question","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":263,"urlcode":"Government","name":"Government"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"}],"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":39501,"type":"discussion","name":"Formulas","excerpt":"I am trying to write an IF statements that allows me to set either an up, sideways or down arrow based on the the difference between two dates. I have found many example and have tried to reverse engineer them however I am not having any luck Basically if the two date fields when subtracted = a number less then or = 7 then…","categoryID":322,"dateInserted":"2019-01-21T14:54:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-21T15:22:16+00:00","insertUserID":75846,"insertUser":{"userID":75846,"name":"NetguyIT","url":"https:\/\/community.smartsheet.com\/profile\/NetguyIT","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-21T14:48:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":75846,"lastUser":{"userID":75846,"name":"NetguyIT","url":"https:\/\/community.smartsheet.com\/profile\/NetguyIT","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-21T14:48:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":55,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/39501\/formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/39501\/formulas","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"}],"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":39346,"type":"discussion","name":"Nested IF for Numbers with Greater Than, Less Than, Etc.","excerpt":"Hello SmartSheet Community! I am trying to get a number that has it's own formula in it, to then be the number that is done in another formula on another cell in the same sheet. I'll go over this to ensure there is no confusion about what I am doing. ====================================================== First, my nested…","categoryID":322,"dateInserted":"2019-01-17T17:58:09+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-19T14:46:36+00:00","insertUserID":74831,"insertUser":{"userID":74831,"name":"Joseph Edwards","url":"https:\/\/community.smartsheet.com\/profile\/Joseph%20Edwards","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-24T14:58:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":74831,"lastUser":{"userID":74831,"name":"Joseph Edwards","url":"https:\/\/community.smartsheet.com\/profile\/Joseph%20Edwards","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-24T14:58:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":1715,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/39346\/nested-if-for-numbers-with-greater-than-less-than-etc","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/39346\/nested-if-for-numbers-with-greater-than-less-than-etc","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/imgur.com\/tIUR3bJ.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet Nested IF Error showing in sheet"},"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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":271,"urlcode":"Services","name":"Services"}],"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}">