Can you return the data from a different column on the same row?

I have a portfolio sheet with multiple projects. The goal is to calculate which of these project studies are both the longest timeline and shortest timeline based on ""Deemed Valid Processing Days". I created a separate column for the formulas, I would like to pull results into a dashboard.

Can I use a nested formula inside of MAX or MIN and have it return the "project name" column instead of the actual value of "Deemed Valid Processing Days"? If so how do which formula and how do I return the value of "project name" column instead of the value of the MAX or MIN formula?

=MAX([Deemed Valid Processing Days]1:[Deemed Valid Processing Days]50)

Thank you,

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Try something like this in a sheet summary field...

    =INDEX([Project Name]:[Project Name], MATCH(MAX([Deemed Valid Processing Days]:[Deemed Valid Processing Days]), [Deemed Valid Processing Days]:[Deemed Valid Processing Days], 0))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!