Convert Cells into a Formula Columns Issues

Options

Hello,

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 https://help.smartsheet.com/articles/2481944?ss_lc=en_US&source=apphelpicon 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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!