Formulas and Calculations

dennis.goudy72296 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

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.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!