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])
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
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.)
that worked, thank you @Ander!
@Ander - thanks ( you have a good eye!) - let the team know.
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 @anon35787480 Something like that ?
Yes! 
This is it! Thank you!
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
a
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
previously with number column types, if you’ll recall.