Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
SUMIF
Hello, I am trying to create a sumif formula to work out a value of column each time a name appears in a different column. I am currently using the below but it keeps coming back with #UNPARSEABLE
=SUMIF([Assigned 1st]:[Assigned 1st], "[Nicola Sutton]", [Job Value]:[Job Value]
Answers
-
Richard,
You can write this a couple way's - Once by manually using the name as the reference "Nicola" =SUMIF([Assigned 1st]:[Assigned 1st], "Nicola", [Job Value]:[Job Value]) or you can automate the formula by using an @row referencing the cell with the persons name =SUMIF([Assigned 1st]:[Assigned 1st], Person@row, [Job Value]:[Job Value])
-
rgochee- Thanks for your help,
I have used this formula and now is comes up with 0, when I use their full name. But when I change the assigned 1st column to just using their first name it works. Will SUMIF only work on singular names?
-
-
Still showing 0, :(
-
Do you mind snipping a screen shot columns and your formula.
-
Hi Richard,
Here are two options. One with the name in the formula and one which reference another cell with the name in it.
Try something like this.
NAME
=SUMIF([Assigned 1st]:[Assigned 1st]; "Nicola Sutton"; [Job Value]:[Job Value])
The same version but with the below changes for convenience.
=SUMIF([Assigned 1st]:[Assigned 1st], "Nicola Sutton", [Job Value]:[Job Value])
REFERENCE
=SUMIF([Assigned 1st]:[Assigned 1st]; [Assigned 1st]@row; [Job Value]:[Job Value])
The same version but with the below changes for convenience.
=SUMIF([Assigned 1st]:[Assigned 1st], [Assigned 1st]@row, [Job Value]:[Job Value])
Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.
Did that work?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thats helped, thank you for your help.
Take care
-
Excellent!
I'm always happy to help!
✅Remember! Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.2K Get Help
- 452 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- How do I edit this formula to turn button yellow when due date is 5 days away. =IF([% Complete]@row = 1, "Green", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row = TODAY(), "Yellow", "Green"))) …
- I need a formula to calculate sets of specific Date columns, and tally those date columns into a % of that set? For e.g. I have 2 groups. Each group has specific columns that make up the set for each …
- Hi, in the image below I have in my "extrusion" column an entry that populates by a formula (in this case "M3406 HEAD TRACK 15' is populating) I'm looking to populate the "Last Cycle Count Date" colum…