功能

0 and when \"Date\" column CONTAINS or FIND \"January\" Therefore if I only selected the first six rows as example, the SPI Quantity cell would return the value of 4. I tried this formula, however didn't work…","categoryID":322,"dateInserted":"2020-01-30T23:03:39+00:00","dateUpdated":null,"dateLastComment":"2020-02-04T12:08:31+00:00","insertUserID":45481,"insertUser":{"userID":45481,"name":"Peta","url":"https:\/\/community.smartsheet.com\/profile\/Peta","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uvnOtxinljw!geVM4IDcDgQ!hffRGLIcWnW","dateLastActive":"2022-11-27T19:41:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":117588,"lastUser":{"userID":117588,"name":"Jayesh Nathani","url":"https:\/\/community.smartsheet.com\/profile\/Jayesh%20Nathani","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/146\/nTXYHAA94OW5V.jpg","dateLastActive":"2021-04-14T14:46:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":95,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/65660\/countifs-contains-or-find-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65660\/countifs-contains-or-find-formula-help","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/707\/TIJJRK0UFH0G.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot.JPG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":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":65661,"type":"question","name":"How do I include Contact List Columns in Concatenation?","excerpt":"I need to create a primary key on a page that includes 3 text columns and 1 contact list. The formula errors when I try to include the contact list, but works fine without it. Is there a way to reference a contact column as text or get it to just read the name in the contact for that cell as text?","categoryID":322,"dateInserted":"2020-01-30T23:09:39+00:00","dateUpdated":null,"dateLastComment":"2020-02-04T11:40:42+00:00","insertUserID":105446,"insertUser":{"userID":105446,"name":"Elliot Holder","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Elliot%20Holder","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-02-03T19:07:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":117588,"lastUser":{"userID":117588,"name":"Jayesh Nathani","url":"https:\/\/community.smartsheet.com\/profile\/Jayesh%20Nathani","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/146\/nTXYHAA94OW5V.jpg","dateLastActive":"2021-04-14T14:46:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":362,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/65661\/how-do-i-include-contact-list-columns-in-concatenation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65661\/how-do-i-include-contact-list-columns-in-concatenation","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-02T09:29:32+00:00","dateAnswered":"2020-01-31T16:05:34+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":247,"urlcode":"Contacts","name":"Contacts"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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":65733,"type":"question","name":"Using IF Statement & DATE","excerpt":"I'm trying to combine formulas that if a check box is clicked, it returns the number 7 to me or else it runs a formula for subtracting dates from TODAY but unfortunately I keep getting #INVALID DATA TYPE =IF(OR(COMPLETE@row, \"7\"), (TODAY() - DATE@row)) Any help would be great appreciated. Thanks.","categoryID":322,"dateInserted":"2020-02-04T03:10:35+00:00","dateUpdated":null,"dateLastComment":"2020-02-04T06:15:43+00:00","insertUserID":118104,"insertUser":{"userID":118104,"name":"bsmith736464","url":"https:\/\/community.smartsheet.com\/profile\/bsmith736464","photoUrl":"https:\/\/lh6.googleusercontent.com\/-AL62_ZOQsfY\/AAAAAAAAAAI\/AAAAAAAAAAA\/ACHi3revdhJaV-8qCsBbS5Q0vvK_CeL2dQ\/photo.jpg","dateLastActive":"2020-02-04T20:37:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":64021,"lastUser":{"userID":64021,"name":"Frank Falco","url":"https:\/\/community.smartsheet.com\/profile\/Frank%20Falco","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/751\/nGNE5C2V439CH.jpeg","dateLastActive":"2023-06-19T01:31:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":252,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/65733\/using-if-statement-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65733\/using-if-statement-date","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-04T20:37:15+00:00","dateAnswered":"2020-02-04T06:15:43+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":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":65714,"type":"question","name":"Trigger reminder on absence of comments","excerpt":"Hi, It looks like the \"modified\" column doesn't update when a comment is added to a row. Comparing this date\/time value to today's date\/time value is the only way I see to automate a reminder when a row has not been updated (and by updated, I mean a comment left on the row, not a cell changing). example - remind 'assignee'…","categoryID":321,"dateInserted":"2020-02-03T15:51:29+00:00","dateUpdated":null,"dateLastComment":"2020-02-03T18:47:12+00:00","insertUserID":70326,"insertUser":{"userID":70326,"name":"jk99","url":"https:\/\/community.smartsheet.com\/profile\/jk99","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-03-02T22:24: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":"2023-06-15T21:50:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":84,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/65714\/trigger-reminder-on-absence-of-comments","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65714\/trigger-reminder-on-absence-of-comments","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"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":65712,"type":"question","name":"Nested Ifs","excerpt":"I need and if statement on a metric sheet that counts if 3 criteria are met. If one column = this If another column = that If last column = \"No\" This is what I have and I though it might work but I get the #UNPARSEABLE error. =COUNTIFS({Range 1}, [Primary Column]3, FIND(AND({Range 3} = [Primary Column]9, {Range 2} \"No\")))…","categoryID":322,"dateInserted":"2020-02-03T15:25:40+00:00","dateUpdated":null,"dateLastComment":"2020-02-03T18:46:09+00:00","insertUserID":115396,"insertUser":{"userID":115396,"name":"Casey Hope","url":"https:\/\/community.smartsheet.com\/profile\/Casey%20Hope","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xRdXMVdnL7o!oR1VqEMDkCQ!pI3O9Gqvj7X","dateLastActive":"2021-02-18T21:43:54+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-15T21:50:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":106,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/65712\/nested-ifs","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65712\/nested-ifs","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-03T18:27:13+00:00","dateAnswered":"2020-02-03T17:36:40+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":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":65658,"type":"question","name":"Resending a Row with attachments","excerpt":"I have an automation set up to send an \"update\"\/\"notify\" a specific person when a new row is added. I didn't select any advanced options. We didn't want him notified EVERY time a small change is made to a row, but there are times he has updated significant information and he essentially wants to resend that row to himself.…","categoryID":321,"dateInserted":"2020-01-30T21:47:23+00:00","dateUpdated":null,"dateLastComment":"2020-02-03T16:33:15+00:00","insertUserID":111676,"insertUser":{"userID":111676,"name":"lauren.waters111676","url":"https:\/\/community.smartsheet.com\/profile\/lauren.waters111676","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-29T16:40:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-19T00:32:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":187,"score":null,"hot":11,"url":"https:\/\/community.smartsheet.com\/discussion\/65658\/resending-a-row-with-attachments","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65658\/resending-a-row-with-attachments","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-03T14:51:55+00:00","dateAnswered":"2020-01-31T12:14:50+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":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">