Convert Cells into a Formula Columns Issues

maltaee

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.

Paul Newcome

To get a formula to work as a column formula, you have to replace all specific row references with "@row".

Impact1

Impact@row

You want the bottom one.

Paul Newcome

To get a formula to work as a column formula, you have to replace all specific row references with "@row".

Impact1

Impact@row

You want the bottom one.