Adding at risk based on health color

I am not sure the formula you have for your health column, but I recreated the referenced columns in your formula and I do not see any issues with the corrected formula @DKazatsky2 provided to meet your criteria as detailed out in your initial request.

All comments

@bobloblaw You have extra parentheses in your AND statement. Try this:

=IF(AND(Health@row = "Red", [End Date]@row < TODAY(3)), 1, 0)

DKazatsky2

Aside from the extra parentheses mentioned above, I believe you are also checking the end date against 3 days from now, as opposed to 3 days ago.

Give this a try: =IF(AND(Health@row = "Red", [End Date]@row < TODAY(-3)), 1, 0)

Hope this helps,

Dave

Thank you both! I will give these a shot!

Looks like neither worked.

@bobloblaw Can you share a screenshot of your sheet with confidential info removed/hidden of course.

DKazatsky2

Have you tried the -3 as suggested above? What behavior are you seeing that needs to be corrected?

@DKazatsky2 Please know that I am complimenting you not critiquing. I used your formula as the example because it met the original request.

DKazatsky2

@JamesB Thanks. Never took it negatively.