Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Copy a formula accross a column - not loose background color
![Roni](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
You have a formula that needs to be populated across all cell in a column.
1) is there a way to do this without using the drag and pull across the column.
The problem I am having is that I am also pasting the format (background color) of the copied cell. My only choice is to redo my color format.
Comments
-
Hello Roni,
One way to automatically and quickly copy a formula down through an entire column and have the row/cell references change would be the Drag Fill option you referred to, but this will also copy the formatting.
A workaround would be to use the Drag Fill option, and leave all the cells highlighted from the fill option. Once you've filled down the formula, you can then click the icon in the toolbar that looks like a pencil in the bottom, which will clear all formats from the selected cells. This would provide the quickest way to remove the formatting after the Drag Fill.
-Zack
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives