Simple sell date - buy date formula
Hey all. Trying to do a column equation that shows how long an item has been sitting on a shelf.
Lets call the two columns Sell Date and Buy Date. I'd like to see the amount of days between Sell Date and Buy Date. If I bought inventory on 1/1 and sold it on 1/10, I'd like it to read "9' for "Days on Shelf" column.
What's the best way to do this?
Answers
-
@Mycelus You could use SmartSheet native functionality and use the column called Duration. You could even show the length of "Days on Shelf" on a Gantt chart.
Otherwise, I use a formula along the lines of ([Sell Date] - [Buy Date]) regularly. The function NETDAYS is a bit more sophisticated.
(I recommend activating a Gantt chart and let the SmartSheet functionality manage it. Just beware of vacation and weekend days.) =days
Cheers,
dm
-
I was able to do =([Sold Date]@row - [Bought Date]@row) and that did the trick, thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 501 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 79 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!