Formula help : Identifying most recent row that meets specific criteria


I am recording contents moving between sites based off a SKU. I want to write a formula in the column shown below "Most Recent" that will identify the row as the most recent row for that specific sku. I'm guessing I need a max or collect formula but can't quite figure out how to write it. Concern with MAX - I could have 5 rows added within a minute that would display different sku numbers and different statuses.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!