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

RichardJ ✭✭
edited 08/03/21 in Formulas and Functions


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


Can someone help me understand why this error is shown in the report view?




  • Genevieve P.
    Genevieve P. Employee Admin

    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).



  • RichardJ
    RichardJ ✭✭
    edited 08/05/21

    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.


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @RichardJ

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!