filling columns -has to be a better way!

Bill Brandt

I have a schedule with close to 2000 lines. I am adding columns that need calculations in them. It currently takes me close to 15 min to either drag the formula down or copy and paste chunks. When I create the column why not provide me an option to enter the formula then and apply that to every row? Smartsheets has been fine for little things here and there but every time I try to use to do real heavy lifting it fails.

J. Craig Williams

Bill,

I do not disagree with your request. Please submit a Product Enhancement.

I do this with the API.

Craig

 

Mike Wilday

 I agree too. Having the ability to double click the little square in the lower-right hand corner and fill the formula down the column would be extremely useful for auto-filling the entire column. 

Kara Lumley

Thanks for the feedback - here is a tip if you are on a PC - 

Select the cell with the formula

Select Ctrl + C to copy

Select Shift + down arrow key which will take you down to the end of your entries

Select Ctrl + D to insert the formulas down.

 

Mike Wilday

Got a tip for Mac users?