Collecting Value of Last Entry Based on Criteria

Ivan Fortuna

Hello there, extremely new to SmartSheets.

Trying to figure out what function to use for a cell to collect the data of the last entry submitted for a specified location on a separate sheet.

Ivan Fortuna

Figured it out! :)

=MAX(COLLECT({Average of Owned Vents NOT In Use}, {Location}, "Austin", {Submission Date}, [Last Submission]@row))

Ivan Fortuna

Figured it out! :)

=MAX(COLLECT({Average of Owned Vents NOT In Use}, {Location}, "Austin", {Submission Date}, [Last Submission]@row))

Genevieve P.

Hi @Ivan Fortuna

I'm glad you figured it out! You can make this a bit smoother by referencing the Location as a cell in the formula as well:

=MAX(COLLECT({Average of Owned Vents NOT In Use}, {Location}, Location@row, {Submission Date}, [Last Submission]@row))