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
- 65.5K Get Help
- 448 Global Discussions
- 145 Industry Talk
- 481 Announcements
- 5.1K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 73 Community Job Board
- 492 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 304 Events
- 37 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!