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
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives