Add points for entries with same name?

Trying to create a formula that will add points for all entries with the same name. Lines with dots below. I can get everything sorted on a report, but need to add up points for each person. Can't figure this part out. Any help is much appreciated!
Best Answer
-
Hi @Mr Keith G
I hope you're well and safe!
Try something like this.
=SUMIF([Team Member]:[Team Member], "Andrée Starå", Points:Points)
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi @Mr Keith G
I hope you're well and safe!
Try something like this.
=SUMIF([Team Member]:[Team Member], "Andrée Starå", Points:Points)
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
It doesn't seem to be adding the points. I wonder if I have to add the name in the brackets?
-
I figured it out. It works, but only if I manually enter the point total. My Point column is a formula depending on Call Off Type.
Help Article Resources
Categories
Check out the Formula Handbook template!