Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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?
