Asset Utilisation Help

Hi all,

I'm trying to create a summary sheet which pulls data from a separate sheet populated from a form.

Basically I want to match and return when an asset was last used (a date - the most recent date to be precise within the last 7 days).

There can be multiple assets in the same cell which is kind of stumping me, I.E cannot use a VLookup so need to separate to match?

Looking for some ideas? I have tried:

=INDEX(COLLECT({Field Reports Range 3}, {Field Reports Range 2}, CONTAINS([Asset ID List]@row), {Field Reports Range 4}, >=TODAY(-7), 1))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!