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...
Help Article Resources
Check out the Formula Handbook template!