Formulas and Calculations
O.K. I have now inserted my formula to calculate a number of miles driven for a given trip. But now I want to copy the formula to the entire column. Right now the formula is just in row 1 of my SS and I know that I can grab the corner of row 1 and drag it down to copy the formula into the other rows but it puts a zero in those blank rows.
Comments

Hi Dennis,
To fill the formula down you can also use:
 Another quick way to fill content down a column is to use the keyboard shortcut Ctrl + D (Windows) or Command + D (Mac).
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

You can add an IF statement before your formula.
=IF(ISBLANK([Ending Miles]@row), "", PUT in the REST OF YOUR FORMULA without the equal sign)
I am assuming Ending Miles is the name of the column.
Help Article Resources
Categories
Check out the Formula Handbook template!