This was soooooo helpful, I recently started my business and was told in my business class for beginners that tracking your miles is soooo important!! And this made that so easy!

This was really helpful & you did an amazing job explaining. I also appreciate the additional info at the end of the video because it is very useful. Thank you!!!

#replay

At 14:09, the calculation for the 3 miles in row 3 was not done when row 3 was created by completing the form. You had to fill in the cell with the calculation independently of the form being submitted. Is there a way to have the calculation done when the Submit of the new form entry is done? Or do you need to drag your formula down to new rows to see the calculation, a manual operation?

@SimplifyOneThing

Жыл бұрын

Thanks for asking a great question! I should do another video to share how to handle making the formula auto-populate when a new row is submitted by the form. The quick answer is using the “arrayformula” function. I hope it helps.

@jcactreasurer5668

Жыл бұрын

@@SimplifyOneThing Yes, it does, thank you! Found some videos on that topic, using the ARRAY.

@SimplifyOneThing

Жыл бұрын

@@jcactreasurer5668 I am so glad. Thanks! I will definitely add that to the training schedule for future.

#replay