# #INCORRECT ARGUMENT SET

Options
✭✭
edited 06/06/22

I've been using this formula for a couple of years on several sheets.

=IF([Current Month]@row = "1", January@row, IF([Current Month]@row = "2", February@row, IF([Current Month]@row = "3", March@row, IF([Current Month]@row = "4", April@row, IF([Current Month]@row = "5", May@row, IF([Current Month]@row = "6", June@row, [Current Month]@row = "7", July@row, IF([Current Month]@row = "8", August@row, IF([Current Month]@row = "9", September@row, IF([Current Month]@row = "10", October@row, IF([Current Month]@row = "11", November@row, IF([Current Month]@row = "12", December@row)))))))))))

Not pretty I know, but it works. I've just returned from 2 week leave and discovered all of these formulas have fallen over, returning "#INCORRECT ARGUMENT SET" Nobody has touched the formulas or the sheets.

Anybody know what's happened?

• ✭✭✭✭✭
Options

Hi @S.I.D.

Looks like you are missing an IF( for your July If statement.

best,

www.MVPOPS.com

• ✭✭✭✭✭✭
Options

Hi @S.I.D.

I hope you're well and safe!

Try something like this.

```=
IF([Current Month]@row = 1, January@row,
IF([Current Month]@row = 2, February@row,
IF([Current Month]@row = 3, March@row,
IF([Current Month]@row = 4, April@row,
IF([Current Month]@row = 5, May@row,
IF([Current Month]@row = 6, June@row,
IF([Current Month]@row = 7, July@row,
IF([Current Month]@row = 8, August@row,
IF([Current Month]@row = 9, September@row,
IF([Current Month]@row = 10, October@row,
IF([Current Month]@row = 11, November@row,
IF([Current Month]@row = 12, December@row)
```

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Works now. Many thanks.

Its odd what the gremlins get up to when you're away.

• ✭✭✭✭✭✭
Options

Excellent!

Happy to help!

Yes, the Gremlins can be a pain. 😉

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!