Receiving INCORRECT ARGUMENT SET when using an IFERROR

Gabriel Barrera
Gabriel Barrera ✭✭✭✭
edited 01/25/23 in Formulas and Functions

This is the error I'm receiving on my sheet summary page. Please note that the sheet is "set up" with columns and necessary formulas, there is just no information entered yet.

Every time I open this sheet, I get the error above. To fix this problem, I just copy the formula, delete it, then re-paste it.

This is after I re-pasted the same exact formula that was giving me an error.

The formula I am using is this. =IFERROR(MEDIAN([Contract Amount]:[Contract Amount]), "Calculation error. Contact Admin.")

This is the formula that I am using. I've looked it over it numerous times, it seems like a pretty simple formula that is hard to mess up on. Does IFERROR not account for #INCORRECT ARGUMENT SET? And why does repasting the same formula in the same exact field "fix the problem"? Shouldn't there also be a 0 in that field as well, since it's calculating nothing? Or should there be my message "Calculation error. Contact Admin."?

Any feedback is appreciated! Thanks!

Best Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    If the sheet is completely blank/unused, then the cells are not just empty. They essentially do not exist. What happens if you put a number in a cell in the column you are pulling into the MEDIAN function?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    IFERROR does not work on ALL errors. I used to have a list, but I can't seem to find it anymore. Basically it works for most, but there are some that will still push through such as the one you are experiencing, unparseable, and blocked.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!