Find highest value and return matching column header
I have to inspect several cavities in a process by using a Smartsheet form. Then, out of this database, I would like to know the highest and lowest cavity weight along with the cavity #. I wonder how can I do that.
Here is an example:
If Cavity 2 has the highest value, and Cavity 1 has the lowest value. I would like to send out an email with the lowest cavity # and value, and the highest cavity # and value. Any idea on how to do that?
I figured that by creating 4 additional columns at the end of the file - (1) Underweight cavity, (2) Underweight Value, (3) Overweight Cavity, (4) Overweight value - could get this info then used these columns to set my email structure.
Email Structure: Cavity X has a value of XXX, and Cavity Y has a value of YYY.
Thank you for any help!