Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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.
Bill,
I do not disagree with your request. Please submit a Product Enhancement.
I do this with the API.
Craig
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.
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.
Got a tip for Mac users?
