Unparseable "IF" Formula

Scott Murray

Can someone help me understand what is 'unparseable" about this formula? =IF(AND(Finish21<=TODAY(), STATUS21=2)), "RED", "GREEN"  Whereas I have a finish date in column "Finish" and a checkbox complete in column "status" and I want to create a red color dot if the date is past and the status is unchecked, otherwise a green dot in this helper column.

Andrée Starå

@Scott Murray

Happy to help!

Try something like this.

=IF(AND(Finish@row<TODAY(),Status@row=0),1,0)

Did that work?

Andrée Starå

Hi Scott,

Change the =2 to =1

1= Box is checked.

Also, change the RED and GREEN to Red and Green.

Make sense?

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!

Scott Murray

Thanks so much Andree. I couldn't get the formula I sent to work with the changes but found this and it seem to function but it check the helper checkbox column regardless of whether or not I checked or left unchecked the status. I am hoping to get it to pull in the past due tasks that I have not checked off. This same formula is used in the row above and below so you can see the results I am describing...thanks for the guidance.

Andrée Starå

@Scott Murray

Happy to help!

Try something like this.

=IF(AND(Finish@row<TODAY(),Status@row=0),1,0)

Did that work?

Scott Murray

I did get this to work too but the same thing happens. The Formula doesn't seem to be picking up the status checked/unchecked properties.

Andrée Starå

@Scott Murray

Remove the "" around the 0 and change the )) after to )

When you use "" arounds something it's interpreted as text.

Paul Newcome

The problem with the formula in your initial screenshot is an extra closing parenthesis after Status21 = 2.

In your most recent, try removing the quotes from around the zero.

Scott Murray

Andree, you nailed it with the =IF(AND(Finish@row<TODAY(),Status@row=0),1,0)

I'm off to the races but will keep in touch for future services if we find we need more.

Andrée Starå

@Scott Murray

Excellent!

Have a fantastic weekend!

Scott Murray

Any thoughts on why I am getting an INCORRECT ARGUMENT with this formula?

?

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

Andrée Starå

@Scott Murray

Adding the same answer here.

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", "")