Copy Values Only Google Sheets

Paste values only

Description

Amazingly enough, the iOS versions of Google Sheets have never allowed you to paste the values of cells only instead of the formulas.

This is incredibly painful, so I fixed it.

Instructions

Copy any cell(s) in a Google Sheet.
Run this shortcut.
Paste in any Google Sheet (or wherever you like, really).

No third party Updater Shortcut required.

This shortcut has an integrated update mechanism called Embed-a-Update. Thanks to the embedded updater, it does not require any external updater shortcut. The shortcut checks for updates itself, so you'll never miss an update and it is super fast.

If this Shortcut doesn’t work as expected, you have suggestions, or an idea to improve it, let me know!

Latest Release Notes

1.1 - Feb. 1, 2020, 10:12 p.m.

Improved experience

Version history

Feedback

@DolceMisto

“ This is incredibly painful, so I fixed it.” It’s true. Thank you so much, you save me a ton of time. Can you please make a Format Painter shorcut ?
Reply · 7 months, 2 weeks ago

@Mbierman Author

hehe I don't think that is really possible in a shortcut. Sorry.
Reply · 7 months, 2 weeks ago

@DolceMisto

Is it possible to make a shortcut that copy everything but except value?
Reply · 7 months, 2 weeks ago

@Mbierman Author

Not currently.
Reply · 7 months, 2 weeks ago

@thesherpa

I have my values rounded down to zero decimal places for display purposes. However, I would like to have at least two decimal places used for calculations, and it appears that the calculations are being performed with only the display numbers. Is this something that could be corrected?
Reply · 2 months, 2 weeks ago

@Mbierman Author

All that's available is what is being displayed.
Reply · 2 months, 2 weeks ago