Your tutorial is gold! When I saw the duration I though I was just going to jump all the time but along the video you provide such handy tips that I had to give an extra attention. Great work!
Thanks for the tutorial, great refresher on something I haven't done in a while. I found the 'edate()' function most useful for generating the drop down for previous months. Much easier than using the 'date()' function.
Do you have a cheat sheet available? I’m trying to input my numbers in Google sheets to create a profit and loss statement as well as learn how to use the same for monthly reports. I have a small meal prep company.
I can't get the unique dropdown to work. The dynamic list works, but the dropdown on the entry page returns an error when I type a unique value. Any additional tips?
Hi, can you make a tutorial with your dashboard that when you drag down the date you want to show it will automatically change the dashboard data.. Thank you :) .. always watching your tutorial
Hi bro, new subscribers here. Could you pls make a video regarding the best google sheet for a self-employed food delivery driver's tax assessment? I'm doing multiple company deliveries at a time. So if I get ur tutorial regarding this matter it will be so helpful for me. Thanks in advance bro😊
Sir, i really need a help how to collect data or creat data sheet effectively situation is in small business where their is 5 people working for me they work in differnt position everyday. So on a same day they all works differnt position differnt staff and they got differnt salary for different work. Mainly i wanna creat a dashboard from that datasets ....
Hi! Thank you for posting. Is there a way to have in the dropdown menú year for example 2022 and 2023 and bring the month belong to every year but without Jun 2022 etc just the Jun?
SAME MACRO ON SEVERAL SHEETS OF THE GOOGLE SHEET FILE . hi, how can I apply the same macro on multiple sheets at the same time? . This is the JavaScript code: . function lamiaprimamacro() { var spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getRange('A1'). activate(); spreadsheet.getCurrentCell(). setValue('MY FIRST MACRO'); spreadsheet.getRange('A2'). activate(); spreadsheet.getCurrentCell(). setValue('TEXT EXAMPLE'); spreadsheet.getRange('A3'). activate(); }; . this the file . . the macro is located in the sheet "Reset Validation" thank you very much
Your tutorial is gold! When I saw the duration I though I was just going to jump all the time but along the video you provide such handy tips that I had to give an extra attention. Great work!
ive completed the other 2 courses, easily have put in like 15 hours creating these. now im at it agian with the 3rd lol.
Thanks for the tutorial, great refresher on something I haven't done in a while. I found the 'edate()' function most useful for generating the drop down for previous months. Much easier than using the 'date()' function.
thank you🙏🙏🙏🙏🙏🙏 you’re the spreadsheet god
Found it very useful! Thank you
Thank you so much sir!! Your videos have been so helpful.
I learn a lot from you...
nice video! very useful, much oblique!
Thank you for this @hustlesheets. Hope you could create a KPI dashboard for a call center dashboard next. 🙏
Do you have a cheat sheet available? I’m trying to input my numbers in Google sheets to create a profit and loss statement as well as learn how to use the same for monthly reports. I have a small meal prep company.
I can't get the unique dropdown to work. The dynamic list works, but the dropdown on the entry page returns an error when I type a unique value. Any additional tips?
Thankyouu for share full course 😭
thank you so much Sir.. this is so helpful :)
I recreated this sheet for our stock forecasting. I showed my wife, and now she thinks I'm the coolest guy ever. 😎
That's what we're striving for here at Hustlesheets
Hi, can you make a tutorial with your dashboard that when you drag down the date you want to show it will automatically change the dashboard data.. Thank you :) .. always watching your tutorial
Thanks a lot 🙏🙏
Good job
How do I enable that green dialog that pops up every time you enter "=" in a cell? That looks really helpful
Hi bro, new subscribers here. Could you pls make a video regarding the best google sheet for a self-employed food delivery driver's tax assessment? I'm doing multiple company deliveries at a time. So if I get ur tutorial regarding this matter it will be so helpful for me. Thanks in advance bro😊
Bro make dashboard with school marks and monthly and weekly progress reports plz
Sir, i really need a help how to collect data or creat data sheet effectively situation is in small business where their is 5 people working for me they work in differnt position everyday. So on a same day they all works differnt position differnt staff and they got differnt salary for different work. Mainly i wanna creat a dashboard from that datasets ....
Hi! Thank you for posting. Is there a way to have in the dropdown menú year for example 2022 and 2023 and bring the month belong to every year but without Jun 2022 etc just the Jun?
@hustlesheets, could you share the code to make the bar color to blue please.
could you make more video about how to creat dashboard with Google studio
should we make dashboards with googlesheet or google studio ?
You should use Data Studio, and use Google Sheets for some of the calculated metrics that are difficult to do in Data Studio
grt
Love the videos; but I work with large data files and Google sheets is far too slow.
Can you not apply the same functions to excel?
Can you create sheets on request as well plz share email to contact
michael@hustlesheets.com :)
SAME MACRO ON SEVERAL SHEETS OF THE GOOGLE SHEET FILE
.
hi, how can I apply the same macro on multiple sheets at the same time?
.
This is the JavaScript code:
.
function lamiaprimamacro() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('A1'). activate();
spreadsheet.getCurrentCell(). setValue('MY FIRST MACRO');
spreadsheet.getRange('A2'). activate();
spreadsheet.getCurrentCell(). setValue('TEXT EXAMPLE');
spreadsheet.getRange('A3'). activate();
};
.
this the file
.
.
the macro is located in the sheet "Reset Validation"
thank you very much