Subtracting Dates - Smartsheet is rounding date/time up

I am trying to subtract two dates to get the duration of time something stayed within a phase. Currently we are trying to use "CreatedDate," the auto-generated field as the "start" and another date field as the "finish", let's call it "Date entered Triage".

The formula [Date Entered Triage] - [Created Date] works great for any instance where [Created Date] is before 5pm. Anything after 5pm looks like it's getting rounded up in the backend to the next day.

To get around this, I have tried using LEFT() to parse out the date from the time, but this is not working. The [Date Entered Triage] - [Created Date] formula then returns an invalid operation - it seems date fields can't be used in a formula if the date itself is derived from a formula.

Has anyone else experienced something similar and found a solution? I feel like this one should be elementary math, but unfortunately is being made more complicated than it needs to be...

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!