Hello,
I manage invoice by using the =NOW() and multiply the =NOW() by the number of day before getting paid by the client. I then use a copy paste value and to recall unpaid invoice I use that formula: =IF(A13>A1;"ONTIME";"RECALL CLIENT") 'EXEMLPE
I would like to know if it if possible when the statut "RECALL CLIENT" is activated as in my attachment, to send me a email for each client to be recalled with their invoice number, Client name, phone number and Total invoice
Thanks graig
Bookmarks