Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Pull other information from "MIN" Rollup result

Topic Labels: Formulas
Solved
Jump to Solution
254 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I am currently working on putting together a price list from our various venders who offer similar products.
One of my tables list the “Generic Product” ID while I have another table with a list of all products we purchase.

I was able to use a rollup easy enough to tell me what the lowest price for that “Generic Product” is but would like for that to also pull the information from that table to tell me which supplier offers the lowest price.

Is there a simple way for me to accomplish this? I have been missing around with some ideas but figured I would ask the community.

1 Solution

Accepted Solutions

Follow the example shown in this video: BuiltOnAir Podcast Season 8 Episode 2 - YouTube

Essentially, you’ll be adding a Formula and a Lookup/Rollup field to one table, and a Lookup/Rollup field to the other.

See Solution in Thread

2 Replies 2

Follow the example shown in this video: BuiltOnAir Podcast Season 8 Episode 2 - YouTube

Essentially, you’ll be adding a Formula and a Lookup/Rollup field to one table, and a Lookup/Rollup field to the other.

This worked perfectly! Thanks so much!