Option to convert to column formula greyed out

Morton35

Hello, I am new to Smartsheet and having some trouble applying a difference between dates formula to an entire column.

The formula concerns 4 columns - Complaint Status (dropdown format column), Date Complaint Received (date format column), Date Complaint Closed (date format column) and Days Open (duration column).

If Complaint Status is Closed, Days Open = (closed date - received date)

If Complaint Status is Open, Days Open = (Today - received date)

Formula being used in the Days Open column:

=IF([Complaint status]@row = "Closed", NETDAYS([Date complaint received]@row, [Date complaint closed]@row), NETDAYS([Date complaint received]@row, TODAY()))

The formula returns the values I need in the Days Open column and I can drag the corner of the cell down into other cells in the column and the formula applies, but the option to apply the formula to the whole column is greyed out and can't be selected.

Is this due to differing column formats (date vs duration) or something else wrong with formula perhaps, is it possible to apply a column formula referencing date columns like this?

Thanks in advance for any advice on this

Carson Penticuff

Try changing the formatting of Days Open to Text/Number.