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
-
Hi Thomas Reilly,
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
Thanks,
Anjanesh Vaidya
Smartsheet Development, Ignatiuz Software
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️
-
Hello Anjanesh,
Yes, need to add the condition. For some reason, I cant figure it out.
Please and thank you in advance.
Tom Reilly
-
Try something like this:
=IF(OR(Checkbox Column]@row = 1, [Payment Due Date]@row = TODAY()), "Green", IF([Payment Due Date]@row< TODAY(), "Red", "Yellow"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!