Quick way to copy formulas across sheets I found

L_123
L_123 ✭✭✭✭✭✭
edited 09/14/21 in Best Practice

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