Unable to Convert to Column Formula?

Robyn M

Using the following formula but Convert to Column Formula not available, how can I update to utilize to column formula function?

=IF([Date Closed]@row <> "", [Date Closed]@row, TODAY()) - [Created Date]@row

John Shane

Robyn,

I copied and pasted your formula into my test bed and was able to convert it to a column formula, so I'm not sure why it not working for you. A couple of quick troubleshooting questions:

1. Are you right clicking in the box with the formula? When I click other boxes in that column, I get the same grayed-out result you do.
2. What is your permission level on the sheet?

Hopefully this is helpful.

Ray Lindstrom

Hi @Robyn M

It looks like you had the closing if parenthesis after the today function instead of at the end of the statement.

Try this: =IF([Date Closed]@row <> "", [Date Closed]@row, TODAY() - [Created Date]@row)

Also your column must be a Date column for this to work.

Hope that helps!

BRgds,

-Ray