I have to do some invoicing and want to know how many days since an invoice was issued. I can sort out how to find the days between two dates but I only have one date to work with here.
Would love if someone could help!
Hi James.. I found a nice template you could utilize below. I'm sure if you email support@smartsheet.com they could help build a formula in this sheet in a new column for your "days since invoiced".
https://www.smartsheet.com/solutions/customer-order-tracking-and-history
Hello All—
Although our Support team is always there to help troubleshoot existing formula behavior, it sounds like you don't have a formula yet; let's fix that!
To be clear, are you looking to take the number of days between your last invoice date and the current date? You can place a formula like =TODAY() - [Invoice Date]1 in a text/number column. This will take the difference between the current date and your invoice date, then provide you with a numeric value.
Let me know if that's not what you were looking for and I can take another look.
Hi Shaine, this worked perfectly. Thank you very much!
Hey,
How am I supposed to type in the "invoice" date?
