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]


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!