looking for an efficient way to calculate the number of weeks
Is there a more efficient way to calculate the number of weeks between a start date and an end date without using intermediary steps or an extra column? Currently, I use a formula to find the difference in days between the two dates and then divide by 7 to get the number of weeks. I'm wondering if there's a more direct formula that can compute the weeks between the start and end dates without needing any additional calculations.
Answers

You can autocalculate event durations, but they only show up in days currently and like you said you'd have to divide by 7 to find the weeks and round up if you want an integer. This might be a nice feature request to submit though as I can see why it would make a good quality of life update!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 429 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!