Unable to Convert to Column Formula?

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


Answers

  • John Shane
    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
    Ray Lindstrom ✭✭✭✭✭✭
    edited 12/22/23

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!