2015年发布的文章
讨论表
类别
受欢迎的标签
We thank you for your patience while we iron out some of the kinks with the new Search UI. We've released two updates today that resolve some of the concerns raised here.<\/p>
- If you are searching for a numeric or alphanumeric term, you will get an exact match of the search term you entered, thereby resolving some of the previous search relevance concerns.<\/li>
- When clicking on a search result, you will go directly to that result instead of the top of the sheet containing that result. However, if you only want to go to the sheet containing the search result, click the icon to the right of the sheet name. <\/li><\/ol>
We'll keep you updated with any new improvements to the Search experience.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-07 12:13:12","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-12-13T17:03:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","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":3}],"tags":[]},{"discussionID":98742,"type":"question","name":"Max(Collect formula","excerpt":"I'm trying to pull in the most recent date of a file, and it looks like =Max(Collect is the way to do it, but I'm having trouble with getting the formula to work. Currently, I have =MAX(COLLECT({Date of Recent Update}, {Parent Folder}, [Delivery Path]@row)) where Parent Folder and Delivery Path would be the reference to…","categoryID":322,"dateInserted":"2022-12-13T22:54:01+00:00","dateUpdated":null,"dateLastComment":"2022-12-14T02:53:56+00:00","insertUserID":154102,"insertUser":{"userID":154102,"name":"krsch88","url":"https:\/\/community.smartsheet.com\/profile\/krsch88","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!20PdP7h22Lw!ZylcWfRoYDo!LUMNgsYDwyZ","dateLastActive":"2022-12-14T00:27:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":139601,"lastUser":{"userID":139601,"name":"jmyzk_cloudsmart_jp","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jmyzk_cloudsmart_jp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZBVD3K8PY0D5\/n7CZ1F4XWEM9Y.JPG","dateLastActive":"2022-12-14T08:33:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3341960277,"url":"https:\/\/community.smartsheet.com\/discussion\/98742\/max-collect-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98742\/max-collect-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":98742,"commentID":354252,"name":"Re: Max(Collect formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/354252#Comment_354252","dateInserted":"2022-12-14T02:53:56+00:00","insertUserID":139601,"insertUser":{"userID":139601,"name":"jmyzk_cloudsmart_jp","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jmyzk_cloudsmart_jp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZBVD3K8PY0D5\/n7CZ1F4XWEM9Y.JPG","dateLastActive":"2022-12-14T08:33:02+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\/JWH4RTA22YUQ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-14T00:31:05+00:00","dateAnswered":"2022-12-14T00:22:10+00:00","acceptedAnswers":[{"commentID":354246,"body":"
I have tested your formula <\/p>
\"=MAX(COLLECT({Date of Recent Update}, {Parent Folder}, [Delivery Path]@row)),\" <\/p>
and it is working with my sheets. 😀<\/span><\/p>
Please take a look at the dashboard below.<\/p>
<\/p>
