Incorrect Arguement

Eric W.

Hi all,

last ditch effort here to help me keep my sanity. I have a formula that is working in one sheet. I've copied the formula and updated the references (as needed) but the formula on the new sheet returns an #INCORRECT ARGUEMENT error.

Original formula (that works)

=IFERROR(IF(WEEKDAY(TODAY()) = 1, COUNTIFS({Activity log | planned date}, TODAY() - 2, {MASTER Schedule - Kiosk Installs COM}, Status@row), IF(WEEKDAY(TODAY()) = 2, COUNTIFS({Activity log | planned date}, TODAY() - 3, {MASTER Schedule - Kiosk Installs COM}, Status@row), COUNTIFS({Activity log | planned date}, TODAY() - 1, {MASTER Schedule - Kiosk Installs COM}, Status@row))), "")

updated formula (that does not)

=IFERROR(IF(WEEKDAY(TODAY()) = 1, COUNTIFS({AR | Planned Inst date}, TODAY() - 2, {MS | Comp/Incomp}, Status@row), IF(WEEKDAY(TODAY()) = 2, COUNTIFS({AR | Planned Inst date}, TODAY() - 3, {MS | Comp/Incomp}, Status@row), COUNTIFS({AR | Planned Inst date}, TODAY() - 1, {MS | Comp/Incomp}, Status@row))), "")

what am I missing? TIA

screenshots included to help that I'm not losing my mind

updated.png

original.png

Paul Newcome

Double check your ranges. It looks like the syntax is correct, so the only thing left is that your range shape/sizes don't match somewhere or two different ranges within the same function are referencing two different sheets.

Paul Newcome

Double check your ranges. It looks like the syntax is correct, so the only thing left is that your range shape/sizes don't match somewhere or two different ranges within the same function are referencing two different sheets.

Eric W.

@Paul Newcome Thank you! that was it. The naming convention I used for my reference sheets messed me up on recreating the formula. The updated version was referencing two different sheets, where the original was referencing a single, same source sheet.

Paul Newcome

Happy to help. 👍️