Convert to Formula Greyed Out

I'm pretty new to Smartsheet and can't figure this out. When I right click ON THE CELL, the "Convert to Column Formula is greyed out"

  • I am an admin
  • I'm the owner of the sheet
  • The formula does NOT contain specific cell references:
  • =IF([Task/Project Type]@row = "Meeting: Once", "0", [Completed Date]@row - [Start/Started Date]@row)

Thanks for any help!



Best Answer

  • Craig H
    Craig H ✭✭
    Answer ✓

    @Andrée Starå

    That does work if I put the formula in another column of type "Text/number". So, it looks like the issue is with the column type. The column type that is causing the issue is of "Duration". Doe column level formulas not work with that column type?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!