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.
Tags:
0
Comments
Hi Dennis,
To fill the formula down you can also use:
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET PARTNER & CONSULTANT / EXPERT
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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.
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.