Returning just one record per name (Talent) showing max total points (Summed Total by Talent)


Hello - trying to determine if this is even possible with my smart sheet. I have multiple rows with the same talent (name) and same max total of points (Summed Total by Talent) as a new row/record is added whenever a form is submitted.

Here is a screen shot:

Will i need to add a new column/formula to just return one record with name (Talent) and highest summed point total (Summed Total by Talent)?

Thank you for the help.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!