How to get max value from comma separated value

Options
Ashish Solanki
Ashish Solanki ✭✭✭
edited 04/26/21 in Smartsheet Basics

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

Answers

  • Cody Holmes
    Cody Holmes ✭✭✭✭
    Options

    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
    Ashish Solanki ✭✭✭
    edited 04/27/21
    Options

    Hi Cody,

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