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

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!