Formula help


Hi Everyone

I am having some difficulties with trying to pull some data. Background of the formula is I am looking to see how much a certain individual spent in 2019 on agencies. I am using the following formula =SUMIFS([Annie Direct]:[Annie Direct] "Patrick Madsen",[Year]:[Year], "2019", [Payment Amount]:[Payment Amount]). However. I keep getting #UNPARSEABLE. is the formula wrong, if so, what should I be using instead?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!