INCORRECT ARGUMENT SET

Scott Murray

Can anyone tell me why this formula returns an "INCORRECT ARGUMENT ...."

=IF(AND(Start@row < TODAY(+30), [% Complete]@row < 1, "Yellow", ""))

Andrée Starå

Hi Scott,

You're missing a parenthesis after 1 and you have one too many at the end.

Also, you don't need to add the + sign before the 30.

Try something like this.

=IF(AND(Start@row < TODAY(30), [% Complete]@row < 1), "Yellow", "")

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

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