Quick way to copy formulas across sheets I found

L_123

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

Andrée Starå

Wow! Amazing find! I've always added a special character and then used search and replace to make it work but this is lightyears better.

Thanks!

https://media.giphy.com/media/12UlfHpF05ielO/giphy.gif

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

Diane Moore

This is an incredible tip! Thank you so much!

L_123

Haha, thanks @Diane Moore , I had forgotten about this and was about to have to do the same thing on another project. Saved me some time reminding me of my own tip :)

@Genevieve P. You might like this one as well.

Genevieve P.

Ooh, thanks for the tag @L_123...moving this over into Best Practice!

Amanda Needham

This is SUPER helpful! Thanks :)

L_123

What it looks like when you aren't clicked into the item to copy cell

What it looks like when you are clicked into the item to copy cell

Trish A

This is outstanding!!!

DKW

I just tried this trick and it no longer works…

NeilKY

Yeah, it's a GREAT accidental feature that they must have "fixed".

Paul Newcome

EDIT: The below is for within the same sheet. In a different sheet will still work using the method outlined by @L_123.

If you find and replace = with =, it will remove the leading apostrophe and convert

'=formula

into

=formula

which will then work as the intended formula.