Incorrect Arguement

Eric W.
Eric W. ✭✭✭✭
edited 09/15/22 in Formulas and Functions

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!