Hello, I cant seem to get my "at risk" column formula to work. I keep getting #Unpars error message.

Tangenna

At risk pic.PNG

Here is the formula I'm using: =IF(AND([END]3<TODAY(),NOT(Status3="Complete")),1,0)

Genevieve P.

Hi @Tangenna

What are your column names?

You will want to make sure your date column is named "END" and that the status column is named "Status".

I would also suggest using @row instead of the row reference of row 3.

Try this:

 =IF(AND(END@row < TODAY(), Status@row <>"Complete"), 1, 0)

If this hasn't helped, can you post a bigger screen capture showing the column names?

Cheers,

Genevieve

Tangenna

Hi Genevieve,

Thanks for your help. I entered to formula above and I'm still getting a #UNPARS error. Here is a larger screen shot of my columns.

Genevieve P.

Hi @Tangenna

Thank you for the screen capture! I see that your END column is actually called "End Date"

Try updating your formula to the following:

 =IF(AND([End Date]@row < TODAY(), Status@row <>"Complete"), 1, 0)

Let me know if that makes sense!

Cheers,

Genevieve