# Unparseable "IF" Formula

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.

• ✭✭✭✭✭✭
edited 06/19/20

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

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

• 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.

• 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.

• ✭✭✭✭✭✭

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

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

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

• ✭✭✭✭✭✭

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.

• 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.

• ✭✭✭✭✭✭

Excellent!

Have a fantastic weekend!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

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

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

?

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

• ✭✭✭✭✭✭

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:[email protected] | 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!