存档的2015个帖子
讨论表
0, 1, 0) to check a box if a row is a parent row. This is a helpful tool when using conditional formatting to format rows which are parents, automatically. We'd like to do a similar thing if a row is a child row, but I cannot think of a way to do perform this logic. Has anyone…","categoryID":317,"dateInserted":"2015-08-11T09:18:44+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-19T18:30:25+00:00","insertUserID":391,"insertUser":{"userID":391,"name":"John Sauber","title":"","url":"https:\/\/community.smartsheet.com\/profile\/John%20Sauber","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/18\/38\/n18381cdb6f38bc6b446fd26a96bafc25.jpg","dateLastActive":"2021-01-05T18:27:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":103216,"lastUser":{"userID":103216,"name":"ib","url":"https:\/\/community.smartsheet.com\/profile\/ib","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-06-30T20:56:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":10,"countViews":2948,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/1849\/check-if-child-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/1849\/check-if-child-row","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":213,"urlcode":"Conditional Formatting","name":"Conditional Formatting"},{"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":2342,"type":"discussion","name":"Workhours per Resource","excerpt":"Hi! Is there a way to set workhours for a particular resource (say the resource can only work on projects for 4 hours a day)? Thanks! ","categoryID":317,"dateInserted":"2015-10-06T02:22:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-19T12:25:23+00:00","insertUserID":3651,"insertUser":{"userID":3651,"name":"Franix Blue","url":"https:\/\/community.smartsheet.com\/profile\/Franix%20Blue","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-10-07T21:07:39+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":68771,"lastUser":{"userID":68771,"name":"Michael Dillenberger","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Dillenberger","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nhjbPynjFyQ!mvHbX9ml1nw!_WKjea1OfKa","dateLastActive":"2020-07-24T16:23:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":7,"countViews":697,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/2342\/workhours-per-resource","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/2342\/workhours-per-resource","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"}],"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":1336,"type":"discussion","name":"COUNTIF with Dates","excerpt":"I am trying to use COUNTIF referencing two Dates columns. The first \"Due Date\" column has dependencies. The second \"Dates\" column is simply a list of all possible due dates from the beginning of the project to the end (with no dependencies). I am trying to create a third column called \"Total Due\" that counts how many tasks…","categoryID":317,"dateInserted":"2015-07-16T12:03:54+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-19T10:43:56+00:00","insertUserID":2543,"insertUser":{"userID":2543,"name":"Greg Lloyd","url":"https:\/\/community.smartsheet.com\/profile\/Greg%20Lloyd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-07-16T11:53:42+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":104561,"lastUser":{"userID":104561,"name":"Amanda Durham-Barnes","url":"https:\/\/community.smartsheet.com\/profile\/Amanda%20Durham-Barnes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-19T10:24:37+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":2241,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/1336\/countif-with-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/1336\/countif-with-dates","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"}],"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":215,"type":"discussion","name":"Editing a template","excerpt":"How can I edit a template to delete a row?","categoryID":317,"dateInserted":"2015-04-30T19:45:19+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-19T07:55:30+00:00","insertUserID":1283,"insertUser":{"userID":1283,"name":"Sylvie Serplet","url":"https:\/\/community.smartsheet.com\/profile\/Sylvie%20Serplet","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-05-03T18:39:51+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":77926,"lastUser":{"userID":77926,"name":"ckelsoe","url":"https:\/\/community.smartsheet.com\/profile\/ckelsoe","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pqDAqe7Vv-Q!xe1CMUaR8KQ!hMRulITRffc","dateLastActive":"2021-05-11T18:52:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":38,"countViews":914,"score":null,"hot":38,"url":"https:\/\/community.smartsheet.com\/discussion\/215\/editing-a-template","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/215\/editing-a-template","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"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":46,"type":"discussion","name":"Can you automatically apply a format to parent rows?","excerpt":"I would like parents rows to be formatted bold automatically in my sheet. I looked into conditional formatting but it did not have an option to reconize parent rows. Is there anyway to do this? ","categoryID":317,"dateInserted":"2015-03-09T18:47:44+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-14T13:15:07+00:00","insertUserID":256,"insertUser":{"userID":256,"name":"SashaR","url":"https:\/\/community.smartsheet.com\/profile\/SashaR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-09-03T19:11:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":104056,"lastUser":{"userID":104056,"name":"teadora","url":"https:\/\/community.smartsheet.com\/profile\/teadora","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-14T12:52:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":13,"countViews":5075,"score":null,"hot":13,"url":"https:\/\/community.smartsheet.com\/discussion\/46\/can-you-automatically-apply-a-format-to-parent-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/46\/can-you-automatically-apply-a-format-to-parent-rows","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":213,"urlcode":"Conditional Formatting","name":"Conditional Formatting"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"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":2316,"type":"discussion","name":"Recurrent tasks in a Gantt chart","excerpt":"Is there a way that you can plot recurrent tasks in a Gantt chart? E.g., writing a monthly report (1 day work) that is due every last Friday of the month. Thanks","categoryID":317,"dateInserted":"2015-09-30T03:36:54+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-12T12:16:47+00:00","insertUserID":3566,"insertUser":{"userID":3566,"name":"Victor van R","url":"https:\/\/community.smartsheet.com\/profile\/Victor%20van%20R","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-02\/76\/8f\/n768fd7367365327e8f30a0f51193533d.jpg","dateLastActive":"2022-06-15T05:11:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":103876,"lastUser":{"userID":103876,"name":"Yann","url":"https:\/\/community.smartsheet.com\/profile\/Yann","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-04-15T15:06:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":8,"countViews":1273,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/2316\/recurrent-tasks-in-a-gantt-chart","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/2316\/recurrent-tasks-in-a-gantt-chart","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"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":91,"type":"discussion","name":"Suggestion for dynamic lists","excerpt":"A feature that would be fantastic for large scale project work would be dynamic lists that could be set up on a sheet and then referred to by drop-down lists in other forms\/sheets. E.g. As more projects or names are added to a sheet these then automatically populate drop-down lists for an \"Add new risk\" form. ","categoryID":317,"dateInserted":"2015-04-08T07:30:27+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-12T08:52:16+00:00","insertUserID":541,"insertUser":{"userID":541,"name":"Chris Winfield","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Winfield","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9f\/e6\/n9fe634774fd823d0e2be574ec3f3a683.jpg","dateLastActive":"2022-03-28T11:26:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":102351,"lastUser":{"userID":102351,"name":"kgb2019","url":"https:\/\/community.smartsheet.com\/profile\/kgb2019","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-26T11:58:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":31,"countViews":1973,"score":1,"hot":32,"url":"https:\/\/community.smartsheet.com\/discussion\/91\/suggestion-for-dynamic-lists","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91\/suggestion-for-dynamic-lists","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">
类别
受欢迎的标签
You will need to substitute each space with %20 so when you are adding the Primary Column value use,<\/p>
=SUBSTITUTE([Primary Column]@row, \" \", \"%20\")\n<\/pre>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-03 11:16:07","updateUser":{"userID":152031,"name":"austinov","url":"https:\/\/community.smartsheet.com\/profile\/austinov","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-03T11:16:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":95022,"type":"question","name":"Determine if form submissions are missing","excerpt":"Hi there. We have 16 geographically dispersed service locations who perform time of service collections and bank deposits. Our finance team needs to capture and reconcile these collections & deposits on a daily basis. I have created a form to collect time of service collection information from each location, and I'm trying…","categoryID":322,"dateInserted":"2022-09-02T17:59:05+00:00","dateUpdated":null,"dateLastComment":"2022-09-02T20:41:55+00:00","insertUserID":99446,"insertUser":{"userID":99446,"name":"JS_NCHC","url":"https:\/\/community.smartsheet.com\/profile\/JS_NCHC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T22:15:46+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":99446,"lastUser":{"userID":99446,"name":"JS_NCHC","url":"https:\/\/community.smartsheet.com\/profile\/JS_NCHC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T22:15:46+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3324293460,"url":"https:\/\/community.smartsheet.com\/discussion\/95022\/determine-if-form-submissions-are-missing","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95022\/determine-if-form-submissions-are-missing","format":"Rich","lastPost":{"discussionID":95022,"commentID":342319,"name":"Re: Determine if form submissions are missing","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/342319#Comment_342319","dateInserted":"2022-09-02T20:41:55+00:00","insertUserID":99446,"insertUser":{"userID":99446,"name":"JS_NCHC","url":"https:\/\/community.smartsheet.com\/profile\/JS_NCHC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T22:15:46+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-02T20:46:38+00:00","dateAnswered":"2022-09-02T20:41:55+00:00","acceptedAnswers":[{"commentID":342319,"body":"Hi again. I figured out the core formula I needed, so I thought I'd update my post in case others have similar questions in the future.<\/p>
Form for submission is part of \"Daily Collections\" sheet, and SITE NAME is the site submitting the form. I created an Audit sheet with a list of SITE NAME's, and look to the Daily Collections sheet to determine if at least one submission matches with SITE NAME, resulting in \"Y\" or \"N\".<\/p>
=IF(COUNTIF({Daily Collections SITE NAME}, =SITE NAME@row) > 0, \"Y\", \"N\")<\/p>
Thanks! 😁<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-02 20:46:38","updateUser":{"userID":99446,"name":"JS_NCHC","url":"https:\/\/community.smartsheet.com\/profile\/JS_NCHC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T22:15:46+00:00","banned":0,"punished":0,"private":false,"label":""}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":95016,"type":"question","name":"Countifs with multiple sheet references and CONTAINS","excerpt":"Hi! I am struggling with how to build the correct formula to provide the result of the following scenario: I am using the Smartsheet \"Fruit Sheet\" to create a formula in the Smartsheet \"Orchard\" Search \"Fruit Sheet\" for any \"Apples\" that may be \"Red\" in the \"Summer\" The sheet has several fruits and several apples. The…","categoryID":322,"dateInserted":"2022-09-02T14:58:09+00:00","dateUpdated":"2022-09-02T15:08:46+00:00","dateLastComment":"2022-09-02T15:55:50+00:00","insertUserID":152024,"insertUser":{"userID":152024,"name":"MoyaC","url":"https:\/\/community.smartsheet.com\/profile\/MoyaC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T15:56:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":152024,"lastUser":{"userID":152024,"name":"MoyaC","url":"https:\/\/community.smartsheet.com\/profile\/MoyaC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T15:56:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":3324266039,"url":"https:\/\/community.smartsheet.com\/discussion\/95016\/countifs-with-multiple-sheet-references-and-contains","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95016\/countifs-with-multiple-sheet-references-and-contains","format":"Rich","lastPost":{"discussionID":95016,"commentID":342299,"name":"Re: Countifs with multiple sheet references and CONTAINS","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/342299#Comment_342299","dateInserted":"2022-09-02T15:55:50+00:00","insertUserID":152024,"insertUser":{"userID":152024,"name":"MoyaC","url":"https:\/\/community.smartsheet.com\/profile\/MoyaC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T15:56:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-02T15:55:57+00:00","dateAnswered":"2022-09-02T15:46:55+00:00","acceptedAnswers":[{"commentID":342297,"body":"
