Welcome!

Finding the greatest value

I am working with two columns.

For purposes here let's call them "Description" and "Total"

I am trying to find the largest value in the Total column for rows 1 - 5 and then assign a different cell the value of the Description for that row.

I can use the following IF(AND statement to compare 1st cell to the remaining other 4 but doing it this way I would have to nest 5 such statements to compare all cells with each other. I have not been able to construct such a long formula without getting the "unparasible" error. Is there a better way to do this?

Trend Result.png

Find more posts tagged with

Comments

Shaine Greenwood

Hello,

I know of one way to do this with a LOOKUP function, but you'd need to switch your columns such that your "Total" column is on left—it needs to be the first column in your lookup table.

Screenshots attached of how this looks and the formula.

Screen Shot 2017-09-07 at 11.27.12 AM.png

Screen Shot 2017-09-07 at 11.27.22 AM.png

khuntington

I am using several columns to hold sum and count totals for other columns. These cells are then linked to a summary sheet that feeds a widget in a Smartsheets Site.

Yet I NOTICED that even though the columns are hidden in the grid (sheet) view they are presented in the "form view" (when double-clicking on the card in Card view.

It is important that these columns are not viewable (to the customer) regardless of the view. Why are they shown in Card View?? What can I do about it??