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?