Create Column Formula on Duration column

_Ernest_

For a duration column being calculated as the difference between two date/time fields, the Create Column Formula option was unavailable. (Converting the column to a text/number column allowed application of the column formula, which then persisted when converting the column back to a Duration column, so the underlying function appears to be fine, it is just the option to do so that is disabled.) Please enable the Create Column Formula operation for any valid data type - durations and others that might suffer the same obstruction.

Thanks! (Reference Case # 07245134 for history, and tech supports request for a product idea submission.)

douglas.martin

I second this request. If a system duration column could include formulas to define the listed values this would give us greater functional options. A formula would allow us to zero out a duration value AND restore the value with the check of a box. As is, we need to manually zero out a row if a task is not needed. IF the task is later needed, the user would need to check the cell history to restore the previous value. A formula would allow us to make multiple changes with a single click of a checkbox.