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.

Drag Fill Formula Horizontally

Options
Hugh McKinney
edited 12/09/19 in Archived 2017 Posts

I am trying to find a way to drag fill formula horizontally so the formula updates the column name in the fomula as it is drag filled horizontally. Drag fill horizontally only copies the original formula across the cells... Am I missing something or is the drag fill function only posible if you drag fill vertically.

Thanks

Comments

  • Adam Overton
    Options

    I don't know why this isn't a thing. You can copy the formula in the first column, and then select all those columns to the right and paste and get the correct relative formulas instead.

     

This discussion has been closed.