Copying SUMIF's formula from one sheet to another

Dina B

I have a few sheets that I need to copy this formula into the Sheet Summary. The formula works in the original sheet (it was AI generated through Smartsheet). When I copy it to the other Sheet Summary, I get "#invalid data type". The formula works for the first two SUMIFS, but when I add the third (Scheduled:Scheduled) sumif, I get the message. The columns names are the same and the values are similar (both sheets contain either a value or a NA.

=SUMIFS(Shipped:Shipped, [Date Manufacturing]:[Date Manufacturing], YEAR(@cell) = 2023) + SUMIFS(Pending:Pending, [Date Manufacturing]:[Date Manufacturing], YEAR(@cell) = 2023) + SUMIFS(Scheduled:Scheduled, [Date Manufacturing]:[Date Manufacturing], YEAR(@cell) = 2023)

Kelly Drake

That error message is usually thrown up when column or sheet summary field types don't match...

https://help.smartsheet.com/articles/2476176-formula-error-messages#toc--invalid-data-type

I'd check to see if those are consistent across your sheets.