Calculations of weeks not showing in whole figures
I am trying to calculate the dwell time for each project, by using the start date & a formula to change the date daily to todays date, however the final figure is coming up with additional decimal places, is there any way to round this figure down / up
This is the formula I am using
Answers
-
There are ROUND, ROUNDUP and ROUNDOWN formulas in SS. For all of these the arguments are the same, ROUND will automatically round up or down based on which whole number is closest, ROUNDUP will round to the next whole number, and ROUNDDOWN to the lower whole number.
i.e =ROUND(([Progress As Of Today]@row - [Start Date of Project]@row) / 7,0)
-
Thank you so much for your help, I will give this a go
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!