How to Create AUTOMATED INVOICES (Autofill) in Google Sheets! *TUTORIAL*

In today's video, I want to show you guys on how you can create a Google Sheets invoice that can autofill customer and item data automatically! This prevents you from typing it manually every time and makes your invoice and billing more efficient! Let me know what you think and feel free to give this a try on your own Google Sheets!

Timestamps:
00:00 Intro
00:20 Simple Invoice
07:07 Advanced Invoice
17:40 Conclusion

Here are some of the formulas that I used! Please change the cells respectively to your own Sheets template, only use as reference!
Total Formula: =SUM(G11:G19)
Grand Total: =G21-G22
VLookup: =IFNA(VLOOKUP(B11,Database!A:C,2),"")

For the VLOOKUP formula, please don't forget to change the "Database" to whatever your data sheet name is, and the range (like A:C) to whatever your defined range is on your data sheet. The number 2 should be changed to whatever corresponding index/column that data is located in as well!

==
Check out my second channel where I post young adult, productivity, and self-improvement content!: https://www.youtube.com/@xLesmana
Want to show some love and support? Buy me a coffee here 😊☕
https://buymeacoffee.com/jeremylesmana
--
Thank you for watching my video! Hope you enjoyed it and don’t forget to subscribe for more content like these~

Some assets that may be used in this video:
Flaticon (icons & logos): https://www.flaticon.com/
Lo-Fi music: @StreamBeatsbyHarrisHeller

Видео How to Create AUTOMATED INVOICES (Autofill) in Google Sheets! *TUTORIAL* канала Jeremy's Tutorials