How do I copy a formula and update a cell reference


I'm an excel user, but new to Smartsheet so I'm still trying to figure out how it works. Please see screenshot attached for reference -

I have a formula in the "Yes_2" cell (circled in red). That formula references another sheet "CSF Questionnaire Range 7" (highlighted yellow).

Next, I copied the formula and pasted it in "No_2" (circled in green). Next I would like to update the reference range on the "CSF Questionnaire", however when I change the reference, it also changes the reference in the "Yes_2" cell, thereby changing the output.

Is there a way to fix this, or do I have to manually type a new formula in each cell that references a new range on the CSF Questionnaire?


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!