Highest and lowest output word
I have a Smartsheet "B" and it uses percentages that are pulled from Smartsheet "A".
I want to add a new formula that at any given time states the highest and lowest percent, but outputs the description. (In the example below - I want the "oranges" and "bananas" to auto populate. What formula would I need?
Help Article Resources
Check out the Formula Handbook template!