Return values from a sheet

Hello, I have a sheet with the following columns:

Recordable (yes/no)

Date

Description

This sheet has a list of all injuries . . many line items.

In a summary sheet I want to return the "Date" from the most recent line item where "Recordable" = "Yes".

On a separate line on the summary sheet, I want to return the "Description" from the most recent line item where "Recordable" = "Yes".

Any help with the correct formula would be greatly appreciated!!!

Find more posts tagged with

Formulas

Accepted answers

All comments

Kleerfyre

Is there a reason you want it on the Summary of this sheet? I would recommend to create a report that you can have filtered for those items unless you absolutely need it on the Summary of the sheet.

Hollie Green

@ctsammon I just realized the formula I originally provided you won't work as it will try to find the Max date even for the "No" the below should be correct. Let me know if it works.

=MAX(COLLECT(Date:Date,Recordable:Recordable,"yes")

=Index(COLLECT(Description:Description,Date:Date,[reference your sheet summary cell with the Max date]#,Recordable:Recordable,"yes")

ctsammon

https://community.smartsheet.com/discussion/comment/377224#Comment_377224

Yes, I want to include the date and comment on a dashboard as the most recent recordable injury as a metric.

Kleerfyre

Then use what Hollie has posted above. It should give you what you want.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.