filling columns -has to be a better way!

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.

Find more posts tagged with

Formulas

Gantt View

Comments

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.