Estimate end date from start date and duration

Hi! I’m trying to estimate the end date for a project based on the start date + a duration. However when I do this with formulas it formats the result as a duration instead of a date.

Any ideas on how to get a date as output?

I tried this:

ToDate(thisRow.[Start date]+thisRow.[Estimated time])

@Ann_k

See if this is what you want. If so, review the column types.

@Ander yup that’s exactly what I want. I have my column types set the same as you, but when I put in the formula it changes the duration to a text field (attached some screenshots). any ideas?

You can see my column type is duration, but in the formula field it’s listed as text. I can’t figure out how to change that to duration

@Ann_k

In your screenshot, the formula “Estimated Time” token has “T” next to it, indicating that it’s a text field – it should have a clock icon next to it. Even though I can also look at the column in your screenshot and see that it appears to be set as a time column.

My hunch is this is buggy behavior, where the column has not registered the proper column type. Try “jiggling” this until you get past the bug. Create the column anew and try hard-coding a time value into it, then delete that value, then add in the formula. (This exact sequence as worked for me with this exact buggy behavior.)

1 Like

that worked, thank you @Ander!

1 Like

@Ann_k :+1:


@mallika We ran into this :bug: previously with number column types, if you’ll recall.

1 Like

@Ander - thanks ( you have a good eye!) - let the team know.

1 Like

How can i modify this formula if is have date and time column and want to have completion time based on duration? e.g. Start 01.12.2022 8:00 Duration 15 min Finish 01.12.2022 8:15 ?

Hi @Mikhail_Mikhasev Something like that ?

Yes! :pray: This is it! Thank you!

@Mikhail_Mikhasev

Nope, normally if you put your mouse in your column “Due” and press “=” and then write your formula, it must apply to every row, even the one you will create later

Check this example

CPT2211210720-914x592
a

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.