Solved: Appsheet upcoming due date

Betti · 03-22-2024 02:16 AM

Hello,

I made a table in which I enter all incoming invoices.

The pending tasks include Overdue in Pending Task, but I also need an other section of a rule in the format "due soon" that shows 5 days before the Due Date/time expired

lynchk21

If you just need a format rule, you can use:

AND(TODAY()+5>=[Due Date],TODAY()<=[Due Date],[Status]="to-do")

This will format all data where the due date is within 5 days of today and is still in the "to-do" status. Change [Due Date] to whatever column name you have for the date tasks are due

View solution in original post

lynchk21

If you just need a format rule, you can use:

AND(TODAY()+5>=[Due Date],TODAY()<=[Due Date],[Status]="to-do")

This will format all data where the due date is within 5 days of today and is still in the "to-do" status. Change [Due Date] to whatever column name you have for the date tasks are due

Betti

Thank You!!!!

One more question, if I want the "Upcoming" name of this header on appear on this form as well, like "Expired" or "Pending", what should I do? It can be solved or would that be too complicated?

I hope you understand what I mean :)))

lynchk21

You still need to have the column you are grouping by (the one that is set to "Overdue" or "Pending") also have an "Upcoming" option. If that column is being calculated with a formula, please share. If it is some other means, let me know.