Formulas and Calculations

04/24/19 Edited 12/09/19

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

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 04/24/19

    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 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.

  • Mike WildayMike Wilday ✭✭✭✭✭

    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. 

Sign In or Register to comment.