在另一个工作表中查找最近的日期
大家好！
我需要一个公式，它在另一个表格中选择与今天日期最近的过去日期。为了提供更多的上下文，另一个表总是将星期一显示为日期。我尝试了索引和数组，但它似乎不工作。希望能有个模板。“今天的日期”单元格是基于一个公式，我插入它作为公式在高亮单元格的参考。
最佳答案
-
L_123 ✭✭✭✭✭✭=max(collect({date help column}，{date help column}， @cell <= today())
答案
类别
Thank you for the quick reply kirstie858<\/strong><\/a>!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-06 04:04:01","updateUser":{"userID":155650,"name":"vponis","url":"https:\/\/community.smartsheet.com\/profile\/vponis","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu123eObw5fLQtcthrpqsoWY319L3hmQyAsPTpm6=s96-c","dateLastActive":"2022-12-06T04:02:48+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":98392,"type":"question","name":"Summary Formula Result in new Formula","excerpt":"I am generating multiple results in a Summary Sheet. I would like to use these results in a new formula within the same Summary, is this possible? SS_Result1 SS_Result2 new formula =sum([SS-Result1]-[SS-Result2]) otherwise I have to combine the formulas within each against themselves, kinda tedious","categoryID":321,"dateInserted":"2022-12-04T20:14:28+00:00","dateUpdated":null,"dateLastComment":"2022-12-05T14:48:26+00:00","insertUserID":154303,"insertUser":{"userID":154303,"name":"SkiPatrolScott","url":"https:\/\/community.smartsheet.com\/profile\/SkiPatrolScott","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:39:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154303,"lastUser":{"userID":154303,"name":"SkiPatrolScott","url":"https:\/\/community.smartsheet.com\/profile\/SkiPatrolScott","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:39:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":null,"hot":3340437774,"url":"https:\/\/community.smartsheet.com\/discussion\/98392\/summary-formula-result-in-new-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98392\/summary-formula-result-in-new-formula","format":"Rich","lastPost":{"discussionID":98392,"commentID":353136,"name":"Re: Summary Formula Result in new Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/353136#Comment_353136","dateInserted":"2022-12-05T14:48:26+00:00","insertUserID":154303,"insertUser":{"userID":154303,"name":"SkiPatrolScott","url":"https:\/\/community.smartsheet.com\/profile\/SkiPatrolScott","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:39:25+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":"2022-12-05T14:48:17+00:00","dateAnswered":"2022-12-04T23:22:27+00:00","acceptedAnswers":[{"commentID":353095,"body":"
Hey @SkiPatrolScott<\/a> <\/p> Yes, you can use an existing summary field in another summary field within the same sheet. You can either click into the formula field of the existing formula to add to new formula, or type out the field name. Summary fields use a # in place of a row indicator. Using your example from above:<\/p>
