Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Days Since (Single Date)
Comments
-
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?
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives