ewhistle
12-06-2006, 05:34 AM
I think it would be beneficial for the invoices tab to have due dates on the list as the first column. For myself the created date is a useful reference but i find it difficult to prioritise who needs chasing up and needs overdue notices sent out.
It would be even better if you could apply conditional formatting to each row as the due and possibly overdue dates pass. I'm just switching over from using excel to keep track of my invoices and used conditional formatting to help me keep track of clients, using a background colour to highlight each client row; blue for invoices due within 7 days switching to orange as they are up to 7 days overdue then red when they are over 7 days overdue.
It would be even better if you could apply conditional formatting to each row as the due and possibly overdue dates pass. I'm just switching over from using excel to keep track of my invoices and used conditional formatting to help me keep track of clients, using a background colour to highlight each client row; blue for invoices due within 7 days switching to orange as they are up to 7 days overdue then red when they are over 7 days overdue.