copy formulas from one sheet to another
Randy Van Winkle
✭✭✭
I have created a block of formulas 4columns x 13rows that are each unique (with complex COUNTIFS formula) counting values etc. with different features. I would like to copy this formula block to another identical sheet. When I copy paste directly or ask it to copy the rows to the new sheet the formulas are erased and only the values show up. Is it possible to copy more than one formula at a time?
Tags:
Comments
-
Try copying a smaller amount, I have had issues where trying to copy too many row or too much data only brought over the values.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!