No video
How to Create a Business Mileage Tracker with Google Forms & Sheets
Hi! In today's live training, we will be building a business mileage tracker using Google Form & Sheets.
#SimplifyTech
#SimplifyOneThing
#TechForEntrepreneurs
#SharingIsCaring
Пікірлер: 8
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