I’m trying to confirm if it’s possible to calculate an Event End Time based on our current fields.
We have a report that we pull into Smartsheet
On Smartsheet:
- Request Start Time (Duration)
- Duration (duration field in minutes)
- Event End Time: (Duration)
Formula's that I tried:
=[Event Start Time]@row + ([Duration]@row / 1440)
=TIMEVALUE([Event Start Time]@row) + (VALUE([Duration]@row) / 1440)
The goal is to automatically calculate the Event End Time by adding the Duration to the Request Start Date.
Before I spend more time troubleshooting, I just want to confirm:
- Is this calculation supported with these field types?
- Or does the Duration field need to be in a specific format (e.g., numeric minutes or time duration format) for this to work properly?
Right now, I haven’t been able to get the calculation to work as expected, so I’m trying to understand if this is a limitation of the setup or something I’m approaching incorrectly.
