Automated DOTs byt date, Need Checkbox TRUE to equeal Green Dot

Thomas Reilly · 09/29/23

So, I am workng on a invoice tracker that currently is using RGY dots for past due invoices by date.

I need to alos formulate that if checkbox 9 is true then status"Green"

=IF([Payment Due Date]7 < TODAY(), "Red", IF([Payment Due Date]7 > TODAY(), "Yellow", IF([Payment Due Date]7 = TODAY(), "Green")))

This will change the payment status to green once the past due date is paid complete.

Any help would be greatly appreciated.

Anjanesh Vaidya · 10/03/23

You mean that, you want to add one more condition in the existing formula, right? That is if checkbox is checked than status to turn green.

Please let me know so I can provide a formula accordingly.

And it will be great if you provide screenshot for context.

Thank You!

Anjanesh Vaidya

Thomas Reilly · 10/19/23

Hello Anjanesh,

Yes, need to add the condition. For some reason, I cant figure it out.

Please and thank you in advance.

Tom Reilly

Paul Newcome · 10/20/23

Try something like this:

=IF(OR(Checkbox Column]@row = 1, [Payment Due Date]@row = TODAY()), "Green", IF([Payment Due Date]@row< TODAY(), "Red", "Yellow"))

Formulas and Functions