#INVALID DATA TYPE - using YEAR(@cell) = YEAR(TODAY()

Ami Veltrie
Ami Veltrie ✭✭✭✭✭✭
edited 07/06/23 in Formulas and Functions

Please help with formula to SUM values in Total Rebate column, IF Reconciled Date year is THIS year.

=SUMIF([Reconciled Date]:[Reconciled Date], =YEAR(@cell) = YEAR(TODAY()), [Total Rebate]:[Total Rebate])

Reconciled Date is a Date Column

Total Rebate is a Text/Number (set to currency format) column that contains a formula: =SUM([Corp Rebate]@row + [Client Rebate]@row)

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    This will essentially ignore any errors with date formatting. It doesn't sound like that is your issue based on your last result, but just to be sure.

    =SUMIF([Reconciled Date]:[Reconciled Date], IFERROR(YEAR(@cell),1) = YEAR(TODAY()), [Total Rebate]:[Total Rebate])

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!