Calculate End Date from "Start Date Plus Number of Days (calculated and rounded up via formula)"
Hello Community!
I'm trying to calculate End dates based off of a hard Start date, and adding a number of Days that I have listed in another cell.
The number of Days is calculated via formula, from one cell that lists Project hours (which I manually input) and each project is assigned to a crew, which have different amounts of hours that can be produced each day (i.e 2 man crew for an 8 hour day = 16 hours produced a day, 3 man crew = 24 etc...) which I then have "Rounded Up" in another column, because for us anything over one day (i.e. 1.25 days) is actually going to take "2" days.
In order to calculate the End date, my Crew Days need to be added to the Start Date. Because Crew Days are calculated via formula, it seems to prevent me from making the column properties a "duration" and therefore adding those days to the Start date.
Is there anyone out there that can offer a solution? I might be just going about this in the wrong order... or perhaps I need to combine formulas?
Thank you
Screen shot also attached for reference!
Comments
-
Hello,
There currently isn’t a way to place a formula in the duration column or any other project column. When you have a moment, please submit a Product Enhancement Request and let our Product team know that you’d like to see this feature added to Smartsheet.
I think the system you have right now is great. You will have to manually add your Crew Days to the duration column that you’re using. Here’s some help content for your perusal:
-
Thank you for your response! I submitted a PER for this function, and appreciate your time.
Kindly,
Marissa
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!