Quick way to copy formulas across sheets I found

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Quick way to copy formulas across sheets I found

Problem: I had the need to copy a list of 26 formulas to 56 sheets maintaining the formulas for each sheet. to increase the data collection across the sheets. All sheets have the same column names. Smartsheet defaults to saving the end result, and doesn't offer the ability to just copy the formulas from one column in one sheet to another.


Solution: I found that if you type ' before the formula, and copy and paste the desired range between sheets, smartsheet doesn't recognize the ' and will post the formula from the cells. This way you can copy an entire rows formulas, and post the formulas into another sheet in rapid succession

Comments

Sign In or Register to comment.