Ignore duplicate child rows and show data of only the latest date effective and lowest price
I'm pulling my hair out trying to solve this one.
I have created a price file of items in smartsheet. Each Item can be purchased from multiple service providers and I am keeping a history of what the item cost per service provider at different times.
I would like to be able to summarise each item at the parent level to identify which service provider can supply the item at the lowest price. Because I'm keeping historic pricing, I need to ignore service provider pricing that has been superseded by a more current date effective.
Can anyone tell me how to do this? I've included a screenshot of my sheet where the formula should return the result: Res Direct, $1.22, 2/12/2022.
Help Article Resources
Check out the Formula Handbook template!