探索领域

<\/p>

=INDEX({Lookup Table Sheet ID Column}, MATCH([Employee Name]@row, {Lookup Table Sheet Name Column}, 0))<\/p>"},{"commentID":313669,"body":"

Try switching the cross sheet references. The first cross sheet reference is the data you want to pull and the second is the data you want to match on. Since you want to pull the ID that should be the first range, and since you are matching on the name that should be the second range.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","dateUpdated":"2022-06-25T14:18:52+00:00","reasonUpdated":"","updatedUser":{"userID":132802,"name":"Ashley Ryder","url":"https:\/\/community.smartsheet.com\/profile\/Ashley%20Ryder","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-25T16:29:34+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":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":231,"urlcode":"Cell linking","name":"Cell linking"}]},{"discussionID":92655,"type":"discussion","name":"Dashboards","excerpt":"Hi - i have a number of sheets for capturing Risks which have drop downs in the some of the columns. My manager wants to pull key data from this into a dashboard to present a visual summary of our risks\/issues, but i cannot seem to get any column with a dropdown in it, into the dashboard - surely this is possible?","categoryID":321,"dateInserted":"2022-06-25T10:08:55+00:00","dateUpdated":null,"dateLastComment":"2022-06-25T10:08:55+00:00","insertUserID":149464,"insertUser":{"userID":149464,"name":"Flump","url":"https:\/\/community.smartsheet.com\/profile\/Flump","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zMdXs1NDzTs!nRVenwaJD4U!bejoTTU4sb0","dateLastActive":"2022-06-25T10:23:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":149464,"lastUser":{"userID":149464,"name":"Flump","url":"https:\/\/community.smartsheet.com\/profile\/Flump","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zMdXs1NDzTs!nRVenwaJD4U!bejoTTU4sb0","dateLastActive":"2022-06-25T10:23:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":9,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/92655\/dashboards","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92655\/dashboards","format":"Rich","lastPost":{"discussionID":92655,"name":"Dashboards","url":"https:\/\/community.smartsheet.com\/discussion\/92655\/dashboards","dateInserted":"2022-06-25T10:08:55+00:00","insertUserID":149464,"insertUser":{"userID":149464,"name":"Flump","url":"https:\/\/community.smartsheet.com\/profile\/Flump","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zMdXs1NDzTs!nRVenwaJD4U!bejoTTU4sb0","dateLastActive":"2022-06-25T10:23:42+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":7,"attributes":{},"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":92464,"type":"question","name":"How to access SCIM APIs?","excerpt":"I'm trying to access the API(https:\/\/scim.smartsheet.com\/v2\/users) by using the Token generated from an Enterprise account with system admin privileges. But, I'm getting an error response as shown below: { \"schemas\": [ \"urn:ietf:params:scim:api:messages:2.0:Error\" ], \"detail\": \"This feature is not enabled for your…","categoryID":320,"dateInserted":"2022-06-22T05:36:20+00:00","dateUpdated":"2022-06-22T09:51:20+00:00","dateLastComment":"2022-06-25T09:41:27+00:00","insertUserID":149273,"insertUser":{"userID":149273,"name":"godson_john","url":"https:\/\/community.smartsheet.com\/profile\/godson_john","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-23T09:56:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":120501,"lastUser":{"userID":120501,"name":"Julio S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/657\/nK3XO551IAZ8H.jpg","dateLastActive":"2022-06-25T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92464\/how-to-access-scim-apis","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92464\/how-to-access-scim-apis","format":"Rich","tagIDs":[438],"lastPost":{"discussionID":92464,"commentID":334400,"name":"Re: How to access SCIM APIs?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/334400#Comment_334400","dateInserted":"2022-06-25T09:41:27+00:00","insertUserID":120501,"insertUser":{"userID":120501,"name":"Julio S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/657\/nK3XO551IAZ8H.jpg","dateLastActive":"2022-06-25T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-25T09:41:27+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","dateUpdated":"2022-06-25T09:41:27+00:00","reasonUpdated":"","updatedUser":{"userID":120501,"name":"Julio S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/657\/nK3XO551IAZ8H.jpg","dateLastActive":"2022-06-25T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","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":[{"tagID":438,"urlcode":"api-developers","name":"API Developers"}]},{"discussionID":92362,"type":"question","name":"Data shuttle for DataTable not replacing data","excerpt":"I've set up a data shuttle to populate my datatable with a workflow to automatically run each week when new data is available in the OneDrive location it's pulling from. The source file has about 300k rows. I have had this set up for two weeks, and my data table has around 600k rows, so it looks like my data is being added…","categoryID":343,"dateInserted":"2022-06-18T18:14:51+00:00","dateUpdated":"2022-06-20T08:23:03+00:00","dateLastComment":"2022-06-25T09:16:09+00:00","insertUserID":141461,"insertUser":{"userID":141461,"name":"carlycrisp","url":"https:\/\/community.smartsheet.com\/profile\/carlycrisp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-18T18:14:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":120501,"lastUser":{"userID":120501,"name":"Julio S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/657\/nK3XO551IAZ8H.jpg","dateLastActive":"2022-06-25T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":27,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92362\/data-shuttle-for-datatable-not-replacing-data","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92362\/data-shuttle-for-datatable-not-replacing-data","format":"Rich","tagIDs":[426],"lastPost":{"discussionID":92362,"commentID":334399,"name":"Re: Data shuttle for DataTable not replacing data","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/334399#Comment_334399","dateInserted":"2022-06-25T09:16:09+00:00","insertUserID":120501,"insertUser":{"userID":120501,"name":"Julio S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/657\/nK3XO551IAZ8H.jpg","dateLastActive":"2022-06-25T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-25T09:16:09+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","dateUpdated":"2022-06-25T09:16:09+00:00","reasonUpdated":"","updatedUser":{"userID":120501,"name":"Julio S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/657\/nK3XO551IAZ8H.jpg","dateLastActive":"2022-06-25T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":[{"tagID":426,"urlcode":"DataTable","name":"DataTable"}]},{"discussionID":92447,"type":"question","name":"Dynamic View Logic Based on Current User","excerpt":"Any ideas on how to implement logic in dynamic view based on current user (other than creating separate views)? For example, if Current User is Advisor, then these fields can be edited. It knows who the current user is because the filter is setup such that if current user is advisor or employee, then row is visible. TIA","categoryID":343,"dateInserted":"2022-06-21T19:03:31+00:00","dateUpdated":"2022-06-22T09:56:53+00:00","dateLastComment":"2022-06-25T08:58:27+00:00","insertUserID":15741,"insertUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-23T11:43:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-06-25T10:09:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/92447\/dynamic-view-logic-based-on-current-user","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92447\/dynamic-view-logic-based-on-current-user","format":"Rich","lastPost":{"discussionID":92447,"commentID":334398,"name":"Re: Dynamic View Logic Based on Current User","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/334398#Comment_334398","dateInserted":"2022-06-25T08:58:27+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-06-25T10:09:51+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-24T23:13:10+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","dateUpdated":"2022-06-24T23:13:10+00:00","reasonUpdated":"","updatedUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJz4VcTCUqqOcHQ9fFrcx-PshvGelJbleisHSXRd=s96-c","dateLastActive":"2022-06-25T00:16:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":[]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[]}},{"label":"Newest Questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","sort":"-dateInserted","limit":5,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","expand":["all","-body"]},"discussions":[{"discussionID":92653,"type":"question","name":"Compare Date","excerpt":"Hello, Sorry for the question since I am new to smartsheet. Is there a way for me to compare dates? For example I have 01\/01\/2022 and 05\/01\/2023 and I want to show 05\/01\/2023 is later then 01\/01\/2022 (05\/01\/2023>01\/01\/2022) Does that work? Thank you all! Amanda","categoryID":322,"dateInserted":"2022-06-24T22:41:58+00:00","dateUpdated":null,"dateLastComment":"2022-06-24T23:15:36+00:00","insertUserID":149459,"insertUser":{"userID":149459,"name":"AmandaCh","url":"https:\/\/community.smartsheet.com\/profile\/AmandaCh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-24T22:42:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":145151,"lastUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJz4VcTCUqqOcHQ9fFrcx-PshvGelJbleisHSXRd=s96-c","dateLastActive":"2022-06-25T00:16:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":9,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92653\/compare-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92653\/compare-date","format":"Rich","lastPost":{"discussionID":92653,"commentID":334391,"name":"Re: Compare Date","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/334391#Comment_334391","dateInserted":"2022-06-24T23:15:36+00:00","insertUserID":145151,"insertUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJz4VcTCUqqOcHQ9fFrcx-PshvGelJbleisHSXRd=s96-c","dateLastActive":"2022-06-25T00:16:34+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-24T23:15:36+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","dateUpdated":"2022-06-24T23:15:36+00:00","reasonUpdated":"","updatedUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJz4VcTCUqqOcHQ9fFrcx-PshvGelJbleisHSXRd=s96-c","dateLastActive":"2022-06-25T00:16:34+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":92649,"type":"question","name":"How to use a Form to gather information on existing data?","excerpt":"Hello, I am looking to use a Form to gather survey answers on existing data in my sheet. For example a project is sent to the Customer and 10 days after the State changes to 'Customer Review', an email notification will go out with the link to the Survey Form. How can I capture the results from the survey form into the…","categoryID":321,"dateInserted":"2022-06-24T19:49:04+00:00","dateUpdated":null,"dateLastComment":"2022-06-24T21:18:30+00:00","insertUserID":135738,"insertUser":{"userID":135738,"name":"Lara Lehnerz","url":"https:\/\/community.smartsheet.com\/profile\/Lara%20Lehnerz","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!0olRvzCFerw!h_FQoaTUXno!p3_UEg74dkz","dateLastActive":"2022-06-24T21:24:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":118542,"lastUser":{"userID":118542,"name":"Shimanta Roy","url":"https:\/\/community.smartsheet.com\/profile\/Shimanta%20Roy","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14Gi-3rzI9OCUTIf7VVkGsIFTAIatbCNn6GOmItUkrw=s96-c","dateLastActive":"2022-06-22T22:46:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":17,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92649\/how-to-use-a-form-to-gather-information-on-existing-data","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92649\/how-to-use-a-form-to-gather-information-on-existing-data","format":"Rich","lastPost":{"discussionID":92649,"commentID":334376,"name":"Re: How to use a Form to gather information on existing data?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/334376#Comment_334376","dateInserted":"2022-06-24T21:18:30+00:00","insertUserID":118542,"insertUser":{"userID":118542,"name":"Shimanta Roy","url":"https:\/\/community.smartsheet.com\/profile\/Shimanta%20Roy","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14Gi-3rzI9OCUTIf7VVkGsIFTAIatbCNn6GOmItUkrw=s96-c","dateLastActive":"2022-06-22T22:46:35+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-24T21:18:30+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","dateUpdated":"2022-06-24T21:18:30+00:00","reasonUpdated":"","updatedUser":{"userID":118542,"name":"Shimanta Roy","url":"https:\/\/community.smartsheet.com\/profile\/Shimanta%20Roy","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14Gi-3rzI9OCUTIf7VVkGsIFTAIatbCNn6GOmItUkrw=s96-c","dateLastActive":"2022-06-22T22:46:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"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":92648,"type":"question","name":"Using data from the Dashboard to a Powerpoint slide","excerpt":"How can I transfer or copy-paste graphs from the Dashboard to a Powerpoint slide?","categoryID":321,"dateInserted":"2022-06-24T19:25:07+00:00","dateUpdated":null,"dateLastComment":"2022-06-24T22:04:33+00:00","insertUserID":146683,"insertUser":{"userID":146683,"name":"Sibali_B","url":"https:\/\/community.smartsheet.com\/profile\/Sibali_B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-24T20:45:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":118542,"lastUser":{"userID":118542,"name":"Shimanta Roy","url":"https:\/\/community.smartsheet.com\/profile\/Shimanta%20Roy","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14Gi-3rzI9OCUTIf7VVkGsIFTAIatbCNn6GOmItUkrw=s96-c","dateLastActive":"2022-06-22T22:46:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":12,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/92648\/using-data-from-the-dashboard-to-a-powerpoint-slide","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92648\/using-data-from-the-dashboard-to-a-powerpoint-slide","format":"Rich","lastPost":{"discussionID":92648,"commentID":334386,"name":"Re: Using data from the Dashboard to a Powerpoint slide","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/334386#Comment_334386","dateInserted":"2022-06-24T22:04:33+00:00","insertUserID":118542,"insertUser":{"userID":118542,"name":"Shimanta Roy","url":"https:\/\/community.smartsheet.com\/profile\/Shimanta%20Roy","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14Gi-3rzI9OCUTIf7VVkGsIFTAIatbCNn6GOmItUkrw=s96-c","dateLastActive":"2022-06-22T22:46:35+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-24T21:24:19+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","dateUpdated":"2022-06-24T21:24:20+00:00","reasonUpdated":"","updatedUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-06-25T10:09:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"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":92647,"type":"question","name":"Checking a box using an IF\/OR statement","excerpt":"Hi, I am trying to check a box if either of these statements are true, but I'm getting an Invalid Data Type error. The \"Operational\" statuses are from a drop down. Data Upload is \"Operational\" OR Retail Survey is \"Operational\" This is what I have: =IF(OR([Data Upload Status]:[Data Upload Status], =\"Operational\", [Retail…","categoryID":322,"dateInserted":"2022-06-24T19:14:45+00:00","dateUpdated":null,"dateLastComment":"2022-06-24T19:37:15+00:00","insertUserID":141331,"insertUser":{"userID":141331,"name":"deb_63_hydracor","url":"https:\/\/community.smartsheet.com\/profile\/deb_63_hydracor","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJzYn23TqUOGU8A4PW0HalCwzLK5YNQsVxHwYcgL=s96-c","dateLastActive":"2022-06-24T20:55:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":141331,"lastUser":{"userID":141331,"name":"deb_63_hydracor","url":"https:\/\/community.smartsheet.com\/profile\/deb_63_hydracor","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJzYn23TqUOGU8A4PW0HalCwzLK5YNQsVxHwYcgL=s96-c","dateLastActive":"2022-06-24T20:55:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":12,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/92647\/checking-a-box-using-an-if-or-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92647\/checking-a-box-using-an-if-or-statement","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":92647,"commentID":334369,"name":"Re: Checking a box using an IF\/OR statement","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/334369#Comment_334369","dateInserted":"2022-06-24T19:37:15+00:00","insertUserID":141331,"insertUser":{"userID":141331,"name":"deb_63_hydracor","url":"https:\/\/community.smartsheet.com\/profile\/deb_63_hydracor","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJzYn23TqUOGU8A4PW0HalCwzLK5YNQsVxHwYcgL=s96-c","dateLastActive":"2022-06-24T20:55:47+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-24T19:32:50+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","dateUpdated":"2022-06-24T19:32:50+00:00","reasonUpdated":"","updatedUser":{"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-06-24T19:30:37+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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":92645,"type":"question","name":"Need help on a formula please.","excerpt":"I am needing some help on a formula. I want to count the number of times the following occurs in two columns of data: 1) where a value is unique\/distinct AND where that value exists in another column with a certain value. Example: Unique station name and and \"city\" . Have tried several combinations and am stumped.…","categoryID":322,"dateInserted":"2022-06-24T18:24:37+00:00","dateUpdated":null,"dateLastComment":"2022-06-24T19:31:58+00:00","insertUserID":149445,"insertUser":{"userID":149445,"name":"MTC","url":"https:\/\/community.smartsheet.com\/profile\/MTC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-24T18:59:39+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-06-24T19:30:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":10,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92645\/need-help-on-a-formula-please","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92645\/need-help-on-a-formula-please","format":"Rich","lastPost":{"discussionID":92645,"commentID":334366,"name":"Re: Need help on a formula please.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/334366#Comment_334366","dateInserted":"2022-06-24T19:31:58+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":"2022-06-24T19:30:37+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-24T19:31:58+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","dateUpdated":"2022-06-24T19:31:58+00:00","reasonUpdated":"","updatedUser":{"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-06-24T19:30:37+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":[]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[]}}],"defaultTabIndex":0}">