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 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.
Help Article Resources
Check out the Formula Handbook template!