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!

Find more posts tagged with

Formulas

Services

Project Management

Cell linking

Comments

Shaine Greenwood

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:

If needed, more information on dependencies can be found here.
Also, more information on areas where formula use is restricted can be found here.

PRPsmartsheets

Thank you for your response! I submitted a PER for this function, and appreciate your time.

Kindly,

Marissa

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?