How do i write a formula to calculate YTD totals of a given category

Here is the formula i started with. It gives me a #unparceable response

=SUMIFS(Amount:Amount, [Expense Category]:[Expense Category], Description@row), Date:Date, YEAR(@cell) = YEAR(TODAY()))

Ive included a screen shot

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!