#INCORRECT ARGUMENT SET

S.I.D.

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?

MVP OPS

Hi @S.I.D.

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

Andrée Starå

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!

Steven Griffiths

Works now. Many thanks.

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

Andrée Starå

@Steven Griffiths

Excellent!

Happy to help!

Yes, the Gremlins can be a pain. 😉

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!