Start daily counter from dropdown choice


Im trying to get my 'countdown' field to start counting days once I select 'Sent' from my dropdown menu.

Basically once I send out an invoice I want it to start counting the days that pass, and show that in my countdown field. It would also be great to hide that countdown field if I select "Paid" from my dropdown menu.

Ninox Profile

Assuming your invoice has a field called 'Date Sent'  that holds the date that it was sent...   You can create a formula field called "Invoice Age" ... something like this. 




Amazing works like a charm! Thanks!