copy from one sheet to another sheet as data, not formulas

Options

i have 2 sheets that i am the owner. i have did a copy sheet as new one, then deleted all the data.

i want to copy rows from Sheet A to Sheet B, but i want the data to be values, not formulas.

i have tried and different ways and still copies the formulas.

got any ideas?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!