Forum Discussion

LFaj10's avatar
LFaj10
Copper Contributor
Mar 07, 2024

Pulling Max out of Multiple Columns and Providing Cell with Max Value

Hi,   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.   We are exporting this int...
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Mar 08, 2024

Hi LFaj10 

 

With Power Query:

 

Info. you didn't provide: which Customer Name(s) should be reported when 2 (or more) SKUs have the same Max Amount (i.e. AW1-123 in above sample). Current version of the query reports the 1st Customer Name (this can be adjusted to report > 1 Customer Name)

Resources