Convert Cells into a Formula Columns Issues
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
-
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.
Answers
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!