# Incorrect Arguement

Options
✭✭✭✭
edited 09/15/22

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

## Best Answer

• ✭✭✭✭✭✭
Answer ✓
Options

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.

## Answers

• ✭✭✭✭✭✭
Answer ✓
Options

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.

• ✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!