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


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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!