Convert Cells into a Formula Columns Issues



I'm getting the below message when I'm trying to convert a cell into a formula. The sheet will receive its data from a form, except for the cells I'm converting.

The column formula syntax isn't quite right, see our help article for more information.

I'm trying to convert both Rating and Recommended Action into a formula column. Below is the Rating.

If I drag the cell, the formula won't stay as cell content will change with any form submission.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!