How to get max value from comma separated value

Ashish Solanki

I want to get max value from the cell value as below.

Please suggest which formula should I use to get max value for comma separated value

Cody Holmes

Hi Ashish,

I honestly do not think this would be possible. Unfortunately, there are not list/array functions within Smarthsheet formulas that would help uncover the max value. There probably is a way if you built a nested if statement, but the nested if length will never be dynamic; it would also be very complicated.

Ashish Solanki

Hi Cody,

Thank you for the response. Could you please suggest nested if statement way?