Continue to get an #Incorrect Argument Set for a column formula but intermittent

Brandon F

I have a formula shown below that checks a product ID from that row against another sheet first to see if it was terminated and return the date listed. If that is good then it checks to see if on that second sheet a final process is recorded with operator information and returns the date:

=IFERROR(IF(COUNT(COLLECT({Product Scheduling Process Date}, {Product Scheduling Lot ID}, [Lot ID]@row, {Product Scheduling Process Status}, "5. Terminated")) > 0, INDEX(COLLECT({Product Scheduling Process Date}, {Product Scheduling Lot ID}, [Lot ID]@row, {Product Scheduling Process Status}, "5. Terminated"), 1), INDEX(COLLECT({Product Scheduling Process Date}, {Product Scheduling Lot ID}, [Lot ID]@row, {Product Scheduling Process Type}, CONTAINS("FINAL", @cell), {Product Scheduling Operator Info}, NOT(ISBLANK(@cell)), {Product Scheduling Operator Info}, <>"N/A"), 1)), "")

I've attached an image of the cell audit to show what I am seeing. Every other cell history entry nothing was actually changed for that row, then that column for the all rows goes to #Incorrect Argument Set, then goes back to normal and returns the appropriate date.

Here is a screenshot of the referenced sheet with the columns Lot ID, Product Type, Process Date, Process, Monitor Info, Operator Info, and the last one Process Status:

Michelle Choate 2

So Smartsheet says whenever you get that error it is one of three causes:

1. For functions that take two ranges: The range sizes don’t match for the function.
2. The function is missing an argument.
3. There is an extra function in the argument.

The resolution is to correct the range size or arguments by adding or removing arguments in the formula.

I know you say it is intermittent. Does that mean it is happening in the other sheet possibly where you are pulling your data from?

Brandon F

Thank you for looking over this. That is the perplexing part of this, most of the rows on the sheet where this column function is no longer have any changing data, just waiting to move to archive, but whatever is causing this changes the cells in the entire column to #INCORRECT ARGUMENT SET then right back to the date that it should have pulled.

StephenB

I'm having this same intermittent problem. Curious if you found a solution. For the time being adding a ", 0" after the 1 in the index function seems to have my formulas working, but I'm not convinced I won't see them error again.

Edit: They indeed just flipped back to #incorrect argument set

Brandon F

Unfortunately, no, I can't say I found a solution, but I also no longer have the issue. I didn't have a better way of formulating the column and just left it until I could figure something else out and after a week it just stopped having the issue and works fine now.