@Nate H<\/a> <\/p>Try this:<\/p>
=INDEX(COLLECT([CL Readmit VAR]:[CL Readmit VAR], Modified:Modified, MAX(Modified:Modified)), 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-30 17:25:24","updateUser":{"userID":94581,"name":"Nate H","url":"https:\/\/community.smartsheet.com\/profile\/Nate%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zclY8_Wr1To!ZNlVWfX5Z7o!6eTqb2RjeNf","dateLastActive":"2022-09-30T17:42:36+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":96096,"type":"question","name":"Shortcut for nested IF function","excerpt":"I am tying columns together in a sheet so that when the user selects a product from a dropdown from a cell, it will automatically populate the product's manufacturer. I can do this using the following: =IF([Product Description]@row = \"Product 1\", \"Company 1\", IF([Product Description]@row = \"Product 2\", \"Company 2\",…","categoryID":322,"dateInserted":"2022-09-30T14:35:02+00:00","dateUpdated":null,"dateLastComment":"2022-09-30T17:42:26+00:00","insertUserID":153039,"insertUser":{"userID":153039,"name":"tmckivergan","url":"https:\/\/community.smartsheet.com\/profile\/tmckivergan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-30T17:39:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":153039,"lastUser":{"userID":153039,"name":"tmckivergan","url":"https:\/\/community.smartsheet.com\/profile\/tmckivergan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-30T17:39:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":42,"score":null,"hot":3329110048,"url":"https:\/\/community.smartsheet.com\/discussion\/96096\/shortcut-for-nested-if-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96096\/shortcut-for-nested-if-function","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":96096,"commentID":345552,"name":"Re: Shortcut for nested IF function","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/345552#Comment_345552","dateInserted":"2022-09-30T17:42:26+00:00","insertUserID":153039,"insertUser":{"userID":153039,"name":"tmckivergan","url":"https:\/\/community.smartsheet.com\/profile\/tmckivergan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-30T17:39: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-30T17:42:00+00:00","dateAnswered":"2022-09-30T17:02:39+00:00","acceptedAnswers":[{"commentID":345543,"body":"
You will want to do a VLOOKUP to another sheet that maintains these relationships of Product to Company. For example lets create a second sheet with two columns called \"Product to Company\"<\/p>
Products Company\n----------------------\nProduct 1 Company 1\nProduct 2 Company 2\nProduct 3 Company 1\nProduct 4 Company 2\nProduct 5 Company 5\n<\/pre>Now in your original sheet use the formula: <\/p>
=VLOOKUP(Product@row, {Product to Company Range 1}, 2, false)\n<\/pre>Notes: <\/p>
- {Product to Company Range 1} is a \"Reference\" to the second sheet that needs to be created. <\/li>
- see the VLOOKUP documents for more details https:\/\/help.smartsheet.com\/function\/vlookup<\/a><\/li><\/ul>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-30 17:42:00","updateUser":{"userID":153039,"name":"tmckivergan","url":"https:\/\/community.smartsheet.com\/profile\/tmckivergan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-30T17:39: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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
杰夫瑞斯曼 ✭✭✭✭✭
Kaleb ✭
