Formulas and Calculations
I know this is a simple formula in SS and Excel but I am having trouble writing it.
In one of my SS's I want to Insert a "Beginning Miles" and then insert an "Ending Miles" column and then finally a "Total Miles Driven" column. To me that formula would need to calculated the sum of two entries and then yield a result of the number of miles for that trip.
I.e.  Beginning Miles = 100 Ending Miles 150 and a result of 50 Miles driven.
I have come close a few times but I keep getting just the sum of the two columns together.
Thanks for your help on this.
Dennis
Comments

Hi Dennis,
Try this.
=[Ending Miles]@row  [Beginning Miles]@row
Did it work?
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:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!