#294

Описание: Download Template: https://urlyte.com/templatedownload/2151
Welcome to our comprehensive tutorial on creating an Automated Monthly Duty Roster in Google Sheet! In previous videos, we have shown you a demo of this template and in this video we'll guide you step-by-step on how to build an efficient and easy-to-use duty roster that automatically updates, ensuring smooth operations for your team. Whether you're managing a small business or a large organization, this automated shift schedule will save you time and reduce errors. This is the second part of this tutorial series.
Purchase Link: https://sahacomputer.co.in/?add-to-ca...

#AutomatedDutyRoster #GoogleSheets #ShiftSchedule #RosterManagement #EmployeeScheduling

📋 What You Will Learn:
Create Settings Sheet
--Creating List for Dropdown List
--Creating Defined Named Range for Dropdown List
--Creating Alternate Row Color (Conditional Formatting)

🛠️ Tools Used:
Google Sheets
Google App Script

🔑 Keywords:
duty Roster, shift Schedule, how to create shift Schedule, how to create duty roster, how to make duty roster in excel, automatic shift schedule excel, how to make duty roster, how to make duty roster format, automatic duty roster excel, duty roster format in excel, duty roster format in excel formula, duty roster shift schedule, staff duty roster in excel, employee shift schedule, automatically create shift schedule in excel, make automatic duty roster

⏰ Timestamps:
0:00 - Introduction
0:36 - Creating Basic Format of Duty Roster
7:54 - Creating Dropdown List for Shift Type
8:33 - Creating Dropdown List for Shift Start
13:33 - Creating Report (Day Wise)
16:50 - Creating Report (Employee Wise)
19:05 - Conclusion

💬 Join the Conversation:
Have any questions or need further assistance? Drop a comment below! We love hearing from you and are here to help.

👍 Like and 🔔Subscribe:
If you found this video helpful, please give it a thumbs up and subscribe to our channel for more tutorials on productivity and management tools. Don't forget to hit 🔔 the bell icon to get notified when we upload new videos!
🔔Subscribehttp://bit.ly/2TTblTG

*******************************************************
~:Must Learn Before You Starting The Series:~
*******************************************************
1. How To Create Static & Dynamic Named Range in Google Sheet:    • #139-Dynamic Named Ranges in Google Sheets...  
2. How to Create Dropdown List in Google Sheet:    • #145-Google Sheet Tutorial: How to Make a ...  
3. How to Hide & Unhide Rows & Columns With Google App Script
4. Conditional Formatting in Google Sheet
5. Formulas:
a) DATEVALUE
b) EOMONTH
c) DATEDIF
d) IF
e) TEXT
f) COUNTIF

*******************************************************
~:This Series Tutorial Link:~
*******************************************************
Demo:    • #292-Automatic Multiple Shift Duty Roster ...  
Part-1:    • #293-How to Create Automatic Multiple Shif...  
Part-2:    • #294-How to Create Automatic Multiple Shif...  
Part-3:    • #295-How to Create Automatic Multiple Shif...  
Part-4:

*******************************************************
~:Related Video Links:~
*******************************************************
Single Shift Duty Roster:    • #163-How to Create an Automatic Shift Sche...  
Multiple Shift Duty Roster:    • #258-How to Create Automated Multiple Shif...  
Multiple Shift Duty Roster With Leaves:    • #267-Multiple Shift Duty Roster with Holid...  
Monthly Attendance Sheet:    • #82-How to Make  Automated Attendance Shee...  
Yearly Attendance Sheet:    • #133-Fully Automated Full Year Attendance ...  
Monthly Attendance Sheet in Google Sheet:    • #142-Automated Attendance Sheet in Google ...  

*******************************************************
~:Support Our Work Financially:~
*******************************************************
Join Us with Youtube Membership:    / @sahacomputerenglish  
Join Us with Patreon:   / scec  
You support us through Thanks button under video
Paypal: paypal.me/manojsaha007
PayTM: 9614866889
Phonepe: 9614866889
GooglePay: 9614866889

*******************************************************
~:Download Links:~
*******************************************************
Project File Type: Premium
Download: https://sahacomputer.co.in/?add-to-ca...
*******************************************************
~:Join us on Social Media :~
*******************************************************
Patreon: 🅿️:   / scec  
Facebook: 📘:   / scecpkt  
Twitter: 🐦:   / manojsaha2016  
Instagram: 📸:

*******************************************************
🚀 Hire Me! 🚀
*******************************************************
If you need assistance with building Excel-based applications, I’m here to help!
Contact Me: [email protected]