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.
Help Article Resources
Check out the Formula Handbook template!