Valid sheet cell value becomes #INCORRECT ARGUMENT SET when aggregated into a report

RichardJ

Hi,

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?

Thanks,

Richard

Genevieve P.

Hi @RichardJ

I'm unable to replicate what you're seeing in the Report, that formula should work.

Do you have it set as a Column Formula?

Try wrapping an IFERROR around the YEAR function, just in case it's causing an error due to text in the date cell, or something similar:

=IF([Date Answered]@row = "", "", (IFERROR(YEAR([Date Answered]@row), "")))

Let me know if this has helped! If not, it would be useful to see a screen capture of your Report (but please block out any sensitive data).

Cheers,

Genevieve

RichardJ

Thanks for the response @Genevieve P.

The Formula is a Column Formula.

The original issue was data related, if the 'Date Answered' was in the format

01/01/18 it would work ok on the sheet and display ok on the Report

01/01/2018 it would work ok on the sheet but display as #INCORRECT ARGUEMENT SET on the report

I've changed the historical data to prevent this.

Thanks

Genevieve P.

Hi @RichardJ

I'm glad you figured out the cause! Thanks for posting your solution.