Valid sheet cell value becomes #INCORRECT ARGUMENT SET when aggregated into a report
I have a formula which displays the correct value at the sheet level
=IF([Date Answered]@row = "", "", (YEAR([Date Answered]@row)))
example output = 2021 or if there isn't a date present the cell would be blank.
However, when I aggregate the sheet rows into a report the cell values show as
#INCORRECT ARGUMENT SET
Can someone help me understand why this error is shown in the report view?
Help Article Resources
Check out the Formula Handbook template!