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
Roni
edited 12/09/19 in Archived 2015 Posts

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

  • Zack S
    Zack S Employee

    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 

This discussion has been closed.