\n ![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/3FESRCR5XE46\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-13 17:54:49","updateUser":{"userID":154576,"name":"AmandaMerrigan","title":"","url":"https:\/\/community.smartsheet.com\/profile\/AmandaMerrigan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-13T19:04:48+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":99665,"type":"question","name":"Need Help With A Formula","excerpt":"How can get the MAX(Inspection Date) by Vehicle and return only those rows in a sheet? (Placing those rows in a new sheet) Example: Rows 2 & 3 should be returned in this case. Row Vehicle Nbr inspection Date Column A Colum B 1 20 12\/19\/22 2 30 08\/17\/22 3 20 01\/10\/23 4 20 11\/30\/22","categoryID":322,"dateInserted":"2023-01-13T14:48:06+00:00","dateUpdated":null,"dateLastComment":"2023-01-13T18:41:05+00:00","insertUserID":148602,"insertUser":{"userID":148602,"name":"Mike B","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-13T15:37:58+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-01-13T19:23:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":11,"score":null,"hot":3347258351,"url":"https:\/\/community.smartsheet.com\/discussion\/99665\/need-help-with-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99665\/need-help-with-a-formula","format":"Rich","lastPost":{"discussionID":99665,"commentID":357111,"name":"Re: Need Help With A Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/357111#Comment_357111","dateInserted":"2023-01-13T18:41:05+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-01-13T19:23:27+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":"2023-01-13T15:37:56+00:00","dateAnswered":"2023-01-13T15:07:04+00:00","acceptedAnswers":[{"commentID":357079,"body":"
You would have to manually input all of the vehicle numbers into the second sheet and then use a MAX\/COLLECT to pull in the date.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-13 15:37:56","updateUser":{"userID":148602,"name":"Mike B","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-13T15:37:58+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":99664,"type":"question","name":"Copy Automation Isn't Completely Working","excerpt":"I've set up a list of associates to pull their daily error count. When the raw total changes from zero, it updates a second sheet that only has these two columns (I have more columns in the original sheet that I don't want pulled for my final sheet, so this is a \"helper\" sheet). I've set an automation for this sheet. When…","categoryID":322,"dateInserted":"2023-01-13T14:28:39+00:00","dateUpdated":null,"dateLastComment":"2023-01-13T18:48:05+00:00","insertUserID":148947,"insertUser":{"userID":148947,"name":"Peelercm","url":"https:\/\/community.smartsheet.com\/profile\/Peelercm","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/MJBE9MY61BQS\/nBB5HS32122XJ.PNG","dateLastActive":"2023-01-13T18:48:51+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-01-13T19:23:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":17,"score":null,"hot":3347257604,"url":"https:\/\/community.smartsheet.com\/discussion\/99664\/copy-automation-isnt-completely-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99664\/copy-automation-isnt-completely-working","format":"Rich","lastPost":{"discussionID":99664,"commentID":357117,"name":"Re: Copy Automation Isn't Completely Working","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/357117#Comment_357117","dateInserted":"2023-01-13T18:48:05+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-01-13T19:23:27+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/SYHM4AZFE5AJ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"User: \"image.png\""},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-13T18:07:42+00:00","dateAnswered":"2023-01-13T15:05:57+00:00","acceptedAnswers":[{"commentID":357078,"body":"
Automations cannot be triggered by a cell that is either linked or contains a cross sheet reference (helps to avoid circular logic breaking things).<\/p>
<\/p>
You would need to set your automation to be date based (or run daily) and set the criteria to be when that number is greater than zero.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-13 18:07:42","updateUser":{"userID":148947,"name":"Peelercm","url":"https:\/\/community.smartsheet.com\/profile\/Peelercm","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/MJBE9MY61BQS\/nBB5HS32122XJ.PNG","dateLastActive":"2023-01-13T18:48:51+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":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
