Smartsheet for Bidding Process

cware10

Hello!

We are currently using a Form to populate a Smartsheet that contains the SKUs selected by the customer for bidding and that customer's bid for that particular SKU. After that information is generated, we are using an INDEX and MATCH combination to look up the SKU and the Pounds Shipped (located in another Smartsheet) to get the total value of the customer's bid * pounds shipped (see green columns). For our analysis, we need to determine the total sum of the values each customer is bidding on (sum of each customer's green columns) and we need to be able to look at each individual SKU to determine what the highest bid placed by the customers is. We included a screenshot with examples of two SKUs. However, our actual data is quite large as we have 313 SKUs and some customers place up to 100 bids. Any information you can provide is extremely appreciated! 

Andrée Starå

https://community.smartsheet.com/discussion/118627/smartsheet-for-bidding-process

Hi,

I hope you're well and safe!

Have you explored using Reports with the grouping/summing feature?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!