Smartsheet for Bidding Process

cware10 ✭✭
edited 03/06/24 in Smartsheet Basics


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!