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.
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!