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
-
You would need to insert a helper checkbox column to check a single entry per person and use that checkbox within a report or sheet filter to only show one of each.
-
Paul, Thank you - the helper column worked perfectly.
Answers
-
The formula in your screenshot should be doing exactly that.
-
Thanks for responding Paul,
Yes you are correct - the formula is returning one name (talent) in the summary field points leader. I apologize for not explaining myself clearly.
My problem is how to show one record for each name (talent) with there points total (summed total by talent) without returning multiple records for each name. Since i have multiple records with each name and point total - not sure if i can return one of each - that will allow me to report on this.
this:
Julie G 614
Kent L 550
Josh T 60
instead of:
Julie G 614
Julie G 614
Julie G 614
Kent L 550
Kent L 550
Josh S 60
Josh S 60
thanks
-
You would need to insert a helper checkbox column to check a single entry per person and use that checkbox within a report or sheet filter to only show one of each.
-
Thank you Paul, I’ll give it a go.
-
Happy to help. 👍️
-
Paul, Thank you - the helper column worked perfectly.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!