Return values from a sheet

Options

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!!!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!