\n <\/img><\/a>\n <\/div>\n<\/div>\n <\/p>
Cheers,<\/p>
Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":107184,"type":"question","name":"JOIN COLLECT with multiple criteria including star - need help!","excerpt":"Trying to do a JOIN COLLECT to collect multiple data points from one column (candidate full name) when there is a match to the current row (faculty@row) and the row is starred (cohort@row). Formula below, getting #INCORRECT ARGUMENT SET error. When I test only the Faculty@row range\/criteria, the formula works. When I test…","snippet":"Trying to do a JOIN COLLECT to collect multiple data points from one column (candidate full name) when there is a match to the current row (faculty@row) and the row is starred…","categoryID":321,"dateInserted":"2023-07-03T17:50:29+00:00","dateUpdated":null,"dateLastComment":"2023-07-03T20:06:36+00:00","insertUserID":128195,"insertUser":{"userID":128195,"name":"Robin Sugiura","url":"https:\/\/community.smartsheet.com\/profile\/Robin%20Sugiura","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-03T18:05:47+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-07-04T17:53:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":22,"score":null,"hot":3376823225,"url":"https:\/\/community.smartsheet.com\/discussion\/107184\/join-collect-with-multiple-criteria-including-star-need-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107184\/join-collect-with-multiple-criteria-including-star-need-help","format":"Rich","lastPost":{"discussionID":107184,"commentID":383582,"name":"Re: JOIN COLLECT with multiple criteria including star - need help!","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383582#Comment_383582","dateInserted":"2023-07-03T20:06:36+00:00","insertUserID":45516,"insertUser":{"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-07-04T17:53:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-04T08:31:35+00:00","dateAnswered":"2023-07-03T17:58:30+00:00","acceptedAnswers":[{"commentID":383559,"body":"
The Cohort range needs to be a full column range the same as the other two ranges.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5440,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
Trending in Using Smartsheet
Lost Sheets Hi, I had two admin accounts and was looking to close the older admin account so changed ownership of several sheets to the admin that was to remain. When I logged in as the retained admin, I noted that many of the sheets had disappeared. These sheets are critical to our business so how can I restore them? I have raised a…
Unwanted calendar view There is a small calendar view appearing to the right of my report when I add the report to the dashboard. Where is this originating from and how do I delete it? It is not meaningful, and it is obscuring part of the report and making it necessary to scroll to see some of the report data.
JOIN COLLECT with multiple criteria including star - need help! Trying to do a JOIN COLLECT to collect multiple data points from one column (candidate full name) when there is a match to the current row (faculty@row) and the row is starred (cohort@row). Formula below, getting #INCORRECT ARGUMENT SET error. When I test only the Faculty@row range/criteria, the formula works. When I test…