- 204
- 8 773 049
Sharon Smith
United States
Registrace 16. 02. 2019
Ready to level up your tech skills? Subscribeđfor expert tutorials, and time-saving tips!
Join me, Sharon Smith, for technical tutorials, courses, and time-saving templates! My goal is to help you solve problems, troubleshoot issues, save valuable time, and have a great day at work!
Here on this Channel, we share everything from in-depth tutorials on technical topics to tips on enhancing office productivity. This Channel will help you gain the confidence and expertise you need to stand out from the crowd.
Whether you're looking to shine in your current role or land your dream job, I'm here to help you get your work done so you can feel good about what you accomplished today. Go ahead and Subscribe, leave a comment, and get ready to become the go-to expert in your organization!
Follow me for helpful tips and tutorials! Thank you!
Join me, Sharon Smith, for technical tutorials, courses, and time-saving templates! My goal is to help you solve problems, troubleshoot issues, save valuable time, and have a great day at work!
Here on this Channel, we share everything from in-depth tutorials on technical topics to tips on enhancing office productivity. This Channel will help you gain the confidence and expertise you need to stand out from the crowd.
Whether you're looking to shine in your current role or land your dream job, I'm here to help you get your work done so you can feel good about what you accomplished today. Go ahead and Subscribe, leave a comment, and get ready to become the go-to expert in your organization!
Follow me for helpful tips and tutorials! Thank you!
How to Automate Weekly Timesheet Template in Excel for Payroll
How to automate a weekly employee timesheet in Excel using formulas to auto-populate the dates in the pay period, how to calculate time in and out including breaks, as well as how to accurately calculate overtime for hours worked over 40 in the work week. We will also create a macro to automatically create 52 weekly timesheets in a Workbook. This template will automatically update the pay period end date, and all days and dates in the pay period based on entering/updating the pay period start date. Also, simply enter base pay rate and all other totals will auto-calculate.
Check out my other videos on timesheets:
czcams.com/video/YTtpcf4vg1A/video.html - Create a Timesheet Template from Scratch
czcams.com/video/HDyyZzC_CPU/video.html - Automate a Bi-Weekly Timesheet
czcams.com/video/dSOKqNcq2I8/video.html - Automate a Semi-Monthly Timesheet
Link to purchase the fully automated templates if you are interested in getting a jump start: www.etsy.com/listing/1745072850/employee-timesheet-template-for-payroll
TIMESTAMPS â°
00:00 Automate Weekly Timesheet in Excel
00:29 Auto-populate Dates in Excel
02:05 Format Time Calculations in Excel
03:44 Calculate Overtime in Excel
05:26 Auto Create Weekly Timesheets with Macros
VBA Code Used in this Video:
Sub CreateWeeklyTimesheets()
Dim ws As Worksheet
Dim i As Integer
Dim newSheet As Worksheet
Dim startDate As Date
' Set the starting date in Week 1's G3 cell
Set ws = ThisWorkbook.Sheets("Week 1")
startDate = ws.Range("G3").Value
' Loop to create Week 2 through Week 52
For i = 2 To 52
' Copy the Week 1 sheet
ws.Copy After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
' Rename the new sheet
Set newSheet = ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
newSheet.Name = "Week " & i
' Update the start date in G3
newSheet.Range("G3").Value = startDate + (i - 1) * 7
Next i
MsgBox "52 weekly timesheets created successfully!"
End Sub
COURSE đ
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro: czcams.com/play/PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs.html
CHANNEL LINK đș
www.youtube.com/@SharonSmith
Visit my Channel page on CZcams to see all my videos, playlists, community posts and more!
TEMPLATES đ
Check out my helpful list of templates available for purchase: creatoriq.cc/43c51cv
Thank you for supporting my channel! đ
FREE DOWNLOADS âŹïž
⊠Visit mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
CONNECT WITH ME đ
Visit my website: www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: www.linkedin.com/in/sharonsmithhr
Twitter: SharonSmithHR
Instagram: sharonsmithlearning
Facebook: SharonSmithLearning
GEAR âïž
đ Blue Yeti USB Microphone: amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
đ± Silent Mouse: amzn.to/3pxpc25 (This is a really cool mouse!)
đ„ Screen Recording Software: techsmith.z6rjha.net/NZG5b
đ Green Screen: amzn.to/2DnHsY2
đž Camera: amzn.to/39KvpQA
đ Live Stream Tool: amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)
RESOURCES đ
âïž JotForm: www.jotform.com/pricing/?
đ„ïž TechSmith Camtasia Screen Recording: techsmith.z6rjha.net/SharonSmithHR
Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
SUPPORT THIS CHANNEL đ
- Hit the "$Thanks" button on any video, or
- Donate through my PayPal link: www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url
If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills.
You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much! â€ïž
PLAYLISTS đ„
†Jotform Tutorials: czcams.com/play/PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD.html
â€Creating Fillable Forms: czcams.com/video/YktZ3B-tyqs/video.html
â€PowerPoint Tutorials: czcams.com/play/PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM.html
†Excel Tutorials: czcams.com/play/PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90.html
†Excel Tips & Tricks: czcams.com/play/PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW.html
†Word Tutorials: czcams.com/play/PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45.html
Check out my other videos on timesheets:
czcams.com/video/YTtpcf4vg1A/video.html - Create a Timesheet Template from Scratch
czcams.com/video/HDyyZzC_CPU/video.html - Automate a Bi-Weekly Timesheet
czcams.com/video/dSOKqNcq2I8/video.html - Automate a Semi-Monthly Timesheet
Link to purchase the fully automated templates if you are interested in getting a jump start: www.etsy.com/listing/1745072850/employee-timesheet-template-for-payroll
TIMESTAMPS â°
00:00 Automate Weekly Timesheet in Excel
00:29 Auto-populate Dates in Excel
02:05 Format Time Calculations in Excel
03:44 Calculate Overtime in Excel
05:26 Auto Create Weekly Timesheets with Macros
VBA Code Used in this Video:
Sub CreateWeeklyTimesheets()
Dim ws As Worksheet
Dim i As Integer
Dim newSheet As Worksheet
Dim startDate As Date
' Set the starting date in Week 1's G3 cell
Set ws = ThisWorkbook.Sheets("Week 1")
startDate = ws.Range("G3").Value
' Loop to create Week 2 through Week 52
For i = 2 To 52
' Copy the Week 1 sheet
ws.Copy After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
' Rename the new sheet
Set newSheet = ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
newSheet.Name = "Week " & i
' Update the start date in G3
newSheet.Range("G3").Value = startDate + (i - 1) * 7
Next i
MsgBox "52 weekly timesheets created successfully!"
End Sub
COURSE đ
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro: czcams.com/play/PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs.html
CHANNEL LINK đș
www.youtube.com/@SharonSmith
Visit my Channel page on CZcams to see all my videos, playlists, community posts and more!
TEMPLATES đ
Check out my helpful list of templates available for purchase: creatoriq.cc/43c51cv
Thank you for supporting my channel! đ
FREE DOWNLOADS âŹïž
⊠Visit mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
CONNECT WITH ME đ
Visit my website: www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: www.linkedin.com/in/sharonsmithhr
Twitter: SharonSmithHR
Instagram: sharonsmithlearning
Facebook: SharonSmithLearning
GEAR âïž
đ Blue Yeti USB Microphone: amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
đ± Silent Mouse: amzn.to/3pxpc25 (This is a really cool mouse!)
đ„ Screen Recording Software: techsmith.z6rjha.net/NZG5b
đ Green Screen: amzn.to/2DnHsY2
đž Camera: amzn.to/39KvpQA
đ Live Stream Tool: amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)
RESOURCES đ
âïž JotForm: www.jotform.com/pricing/?
đ„ïž TechSmith Camtasia Screen Recording: techsmith.z6rjha.net/SharonSmithHR
Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
SUPPORT THIS CHANNEL đ
- Hit the "$Thanks" button on any video, or
- Donate through my PayPal link: www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url
If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills.
You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much! â€ïž
PLAYLISTS đ„
†Jotform Tutorials: czcams.com/play/PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD.html
â€Creating Fillable Forms: czcams.com/video/YktZ3B-tyqs/video.html
â€PowerPoint Tutorials: czcams.com/play/PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM.html
†Excel Tutorials: czcams.com/play/PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90.html
†Excel Tips & Tricks: czcams.com/play/PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW.html
†Word Tutorials: czcams.com/play/PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45.html
zhlĂ©dnutĂ: 318
Video
How to Automate Semi-Monthly Employee Timesheet Template in Excel for Payroll
zhlĂ©dnutĂ 378PĆed 14 dny
How to automate a semi-monthly employee timesheet in Excel using formulas to auto-populate the dates in the pay period, and use special conditional formatting tricks to hide or display all the dates in your pay period range on the timesheet. We'll set up a drop-down list for PTO type selection, and then see how to set it up for calculating hours, overtime, and total pay. This template will auto...
How to Automate Bi-Weekly Timesheet Template in Excel for Payroll
zhlĂ©dnutĂ 1,2KPĆed 21 dnem
How to automate a bi-weekly timesheet in Excel using special formulas to auto-populate the dates in the pay period, we'll set up a drop-down list for PTO type selection, and then see how to set it up for calculating hours, overtime, and total pay. This template will automatically update the pay period end date, and all days and dates in the pay period based on entering/updating the pay period s...
How to Create Employee Timesheet Template in Excel for Payroll - Design a Bi-Weekly Timesheet
zhlĂ©dnutĂ 1,2KPĆed mÄsĂcem
How to create an employee timesheet template in Excel for Payroll from scratch. Weâll design a template for inputting daily hours for a bi-weekly pay period. This bi-weekly timesheet template can be printed or filled in electronically. You'll see how to format the spreadsheet, draw lines and tables, insert proper column headers and create signature lines. We'll create custom margins to ensure t...
Footnotes in Word - Insert, Customize, Convert & Delete Footnotes and Endnotes - Step-By-Step
zhlĂ©dnutĂ 491PĆed mÄsĂcem
How to create Footnotes and Endnotes in Microsoft Word. You'll learn how to insert, customize, convert, and delete Footnotes & Endnotes. Adding Footnotes and Endnotes to your word documents is easy and you can modify how the superscripts appear, as well as delete them and ensure proper auto-renumbering occurs. Footnotes and Endnotes are useful for adding references, explanations, or comments to...
How to Auto Format Chapters in Word - Record a Macro & Make Chapter Headings go to Center of Page
zhlĂ©dnutĂ 533PĆed 2 mÄsĂci
How to auto format Chapters in Word so they appear centered on single pages in your document. We'll do this by creating a Macro with a shortcut button on your Quick Access Toolbar. This helps you automate a task in Word that would normally be repetitive and time consuming if you did it manually. Save time by assigning your Macro to an icon button on the Ribbon or Quick Access Toolbar. We'll als...
How to Create a Progress Circle Chart in Excel - Dynamically Display Percentage of Completion
zhlĂ©dnutĂ 966PĆed 2 mÄsĂci
How to create a progress circle chart in Excel to use as a progress tracker and dynamically display percentage of completion towards a goal. This will be a doughnut chart that will show the percentage of a budget spent and will display in the middle of the circle and will dynamically update as your data is entered. We'll also format the chart to make it stand out. Then you'll see how to use con...
Create a Reset Button in PDF Fillable Forms in Adobe Acrobat Pro - Reset Form Fields in PDF
zhlĂ©dnutĂ 2,1KPĆed 3 mÄsĂci
How to create a reset form button in your PDF fillable form with Adobe Acrobat Pro. Add a button to your PDF form that users can click to clear all the form field data so they can quickly and easily reuse the form. This button is easy to program and format and is a helpful tool for forms that need to be reused often. TIMESTAMPS â° 00:00 Create Reset a Form Button in PDF 00:14 Prepare a PDF Form ...
Create a Reset Form Button in Word - How to Reset Form Fields in Word Fillable Forms
zhlĂ©dnutĂ 2,4KPĆed 3 mÄsĂci
How to reset form fields in a Word fillable form by adding an ActiveX command button that when a user clicks it, all of the form fields will be cleared out. Create a reset form button in Word that will work to clear both Legacy form fields and Content Control form fields. We will insert a command button on our form and then program the button with the VBA code below. This button will uncheck a ...
How to Create a Fillable Form in Word for Mac
zhlĂ©dnutĂ 6KPĆed 4 mÄsĂci
Learn how to create a fillable form in Word for Mac that has form fields including text boxes, drop-down lists, and checkboxes. See how to configure options in your form fields like setting a maximum character limit and forcing date formatting. In this video, we will build and format this form template from scratch with tables and section headers. But in case you already have your form template...
Add Shortcuts to Ribbon in Excel - Speed Up your Excel Workflow using the Quick Access Toolbar
zhlĂ©dnutĂ 881PĆed 5 mÄsĂci
Speed up your Excel workflow by adding shortcuts to the Ribbon in Excel. Personalize the Quick Access Toolbar and arrange icons for the commands you use most frequently. Get to your favorite commands and shortcuts in fewer clicks by adding them to a custom group on any tab in Excel. In this example, we create a custom group on the Home tab next to the font area on the Ribbon where we place the ...
How to Create Sheet Tabs from a List - Then Make a Table of Contents with Links
zhlĂ©dnutĂ 1,8KPĆed 5 mÄsĂci
How to automatically generate multiple sheet tabs in your Excel workbook based on an existing list of values. Create sheet tabs from your list then make a table of contents tab with hyperlinks to all the other tabs. Generate your tabs automatically without having to manually type them out and without VBA. Use this Pivot Table trick to save time and auto create multiple sheet tabs from your list...
Set a Maximum Character Length in Word Fillable Form - Set Max Character Limit
zhlĂ©dnutĂ 6KPĆed 6 mÄsĂci
How to set a maximum character length on a text form field in Microsoft Word. Specify the character limit for a text form field in Word and stop form cells from expanding. This is something you can set up if you need to limit how much a user types into a form field and prevent the field from expanding your document formatting. By default, form fields accommodate an unlimited number of character...
How to Create a Fillable Form in Google Docs
zhlĂ©dnutĂ 26KPĆed 6 mÄsĂci
Learn how to create fillable forms in Google Docs including form elements like text fields, dropdown list selections, and checkboxes. In this step-by-step tutorial we will create a fillable form in Google Docs from scratch. See how to insert and place a logo on your form, then how to use tables and borders to create fillable text boxes on your Google Doc. You'll see how to insert and set up dro...
Create Date Countdown in Excel - Countdown Timer of Days Remaining
zhlĂ©dnutĂ 14KPĆed 6 mÄsĂci
How to create a Date Countdown in Excel to show you both the number of calendar days remaining until an event date, as well as how to calculate the number of working days left between now and that particular date. If you need to count "days left" or "days to go" to a particular date, you can achieve this in a way that will automatically update whenever you open the workbook by using the TODAY()...
Auto Populate Form Fields in Adobe PDFs - Repeating a Field in Other Parts of Your PDF
zhlĂ©dnutĂ 11KPĆed 6 mÄsĂci
Auto Populate Form Fields in Adobe PDFs - Repeating a Field in Other Parts of Your PDF
How to Create a Table of Contents with Hyperlinks in Excel
zhlĂ©dnutĂ 11KPĆed 6 mÄsĂci
How to Create a Table of Contents with Hyperlinks in Excel
Export PDF Form Field Data from Adobe Acrobat Pro to Excel - Adobe Acrobat Forms Data Collection
zhlĂ©dnutĂ 11KPĆed 6 mÄsĂci
Export PDF Form Field Data from Adobe Acrobat Pro to Excel - Adobe Acrobat Forms Data Collection
Make Text See-Through in PowerPoint - Cool Text Transparency Technique
zhlĂ©dnutĂ 10KPĆed 8 mÄsĂci
Make Text See-Through in PowerPoint - Cool Text Transparency Technique
How to Analyze Data Quickly in Excel - Using Excel's Built-in AI Features
zhlĂ©dnutĂ 1,5KPĆed 8 mÄsĂci
How to Analyze Data Quickly in Excel - Using Excel's Built-in AI Features
How to Insert a Dynamic Pivot Chart in PowerPoint - Excel to PowerPoint Integration
zhlĂ©dnutĂ 4,8KPĆed 9 mÄsĂci
How to Insert a Dynamic Pivot Chart in PowerPoint - Excel to PowerPoint Integration
Simplifying Pivot Tables with Timelines and Slicers - Data Visualization Made Easy
zhlĂ©dnutĂ 1KPĆed 9 mÄsĂci
Simplifying Pivot Tables with Timelines and Slicers - Data Visualization Made Easy
How to Add a Calculated Field to a Pivot Table in Excel - Profit Margin PivotTable Formula Example
zhlĂ©dnutĂ 3,8KPĆed 9 mÄsĂci
How to Add a Calculated Field to a Pivot Table in Excel - Profit Margin PivotTable Formula Example
How to Create Pivot Tables in Excel to Analyze Data - Pivot Tables Made Easy for Beginners
zhlĂ©dnutĂ 3KPĆed 9 mÄsĂci
How to Create Pivot Tables in Excel to Analyze Data - Pivot Tables Made Easy for Beginners
How to Hide Confidential Data in Excel - Hiding Social Security Numbers & Credit Card Numbers
zhlĂ©dnutĂ 4KPĆed 9 mÄsĂci
How to Hide Confidential Data in Excel - Hiding Social Security Numbers & Credit Card Numbers
Automate Data Clean-up with Power Query - Auto Format & Combine Multiple Sheets - Save Time
zhlĂ©dnutĂ 3,4KPĆed 9 mÄsĂci
Automate Data Clean-up with Power Query - Auto Format & Combine Multiple Sheets - Save Time
How to Reset Calculated Field to Zero in Adobe Acrobat Pro PDF Form
zhlĂ©dnutĂ 1,7KPĆed 10 mÄsĂci
How to Reset Calculated Field to Zero in Adobe Acrobat Pro PDF Form
How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP
zhlĂ©dnutĂ 13KPĆed 10 mÄsĂci
How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP
Create Engaging PowerPoint Presentations With Free Visual Tools
zhlĂ©dnutĂ 1KPĆed 10 mÄsĂci
Create Engaging PowerPoint Presentations With Free Visual Tools
How to Add a Photo to Header or Footer and Make it a Circle in Microsoft Word
zhlĂ©dnutĂ 4,2KPĆed 10 mÄsĂci
How to Add a Photo to Header or Footer and Make it a Circle in Microsoft Word
I hid my sheet. Now I cant see to get it back. I am not given the options for the sheet nor any other sheets in the workbook when I go back in. Those left side windows are gone. H.E.L.Pđ
How do you add a drop down list reset?
Wow, that was such a great help. Thank you!!
There's a difference between "electronic" signature and "digital" signature. The latter is a certificate that goes through a validation process. I guess this video is out of date.
While typing in some form field, first letter is coming in small font as i desire and second letter onwards font size gets changing bigger automatically. How to correct it
I miss the part that you teach how to create a submit button
Hello! Here is my video on how to insert a Submit button on PDF forms: czcams.com/video/1iczBlPYREE/video.html. Hope this helps! Thanks for watching!
Your videos are always so helpful. On different topic related to word. Is there such a code that will compare 2 bookmarks based on text entered by user and if there is text (any text not specific text) in one it enters the text from that bookmark but if there is no text in that bookmark then it enters the text entered in the other bookmark?
How to you get it to return 'Yes' or 'No' rather than True or False?
Thank you for this, it is amazing. Do you by chance have a video that goes off/hand in hand with this inventory sheet to track costs for the year?
Good, thanks for video tutorials.
Glad to help! Thanks for watching!
Sharon, you are always equipped with the most helpful information and knowledge! Your presentation is excellent! Thank you so much!!
Thank you so much, Linda! Iâm so glad you find my videos helpful! Thanks for taking time to leave a nice comment!
Quite nice explanation
Thank you for watching! Glad you found it helpful!
Please make a series on Power BI with details.
Thanks for the suggestions! Take care!
Superb Sharon nice to see you again after the break. Love â€ïž u mam
Thank you!! Hope you are doing well! Thanks for watching!
Glad I came across your channel, you make it so easy to follow along.
I'm so glad to hear that! Thanks for watching my videos!
Wow!!! thank you so much!!! So clear, concise, and easy to understand.
I'm so glad to hear that! Thanks for watching my videos!
Started watching your videos recently. They are quite helpful. Thanks and lots of love from Sri Lanka!
Hello and thank you so much for watching my videos and for subscribing to my Channel! I'm so glad you found me and that you find my videos helpful. Take care!
thank you sooo much !!
Glad you found it helpful! Thanks for watching!
Thanks a lot for explaining it easily. Helped with my proposal writing..
That is awesome! Good luck with your proposals! Thanks for watching!
Thank you for creating a great videos I wish I have seen your video before I worked on pdf forms I struggled so much but got the hang of it but this definitely helps save time and to understand more clearly and how to use the options in adobe acrobat. Thank you for sharing your knowledge and making it easier to learn!
I'm so glad you have found my Adobe Acrobat videos helpful! Glad to help and thanks so much for watching my videos!
My formula keeps changing cells down by one for sheet 2 so I'm not getting the correct answers. Nothing of any videos I've watched is helping....frustrating the crap outta me and supposed to be so easy to do
Thank you!
Thanks for watching!
loving the way you teach, im dyslexic and a beginner, so the voice over is so helpful, thanks sharon
Thanks so much! I'm so glad you find my videos helpful! I'm glad you are learning from my videos. My best to you! Take care!
Thumbs up
Thank you! Thanks for watching!
Hi Sharon, thanks again for your helpful videos! I have a problem: I created a fillable form in word with Content Control form fields. I need to insert an image content control in the header and footer of the page to allow the customer to insert their letterhead but I can't. I believe that Word does not allow the insertion of form fields in the header and footer of the page. Is it correct? How can I solve it?
Thank you very much Sharon! Your videos are tremendously useful. Only one question: which are the criteria to use Legacy Tools or Content Control form fields?
Can you help me please? I have a protected Word form that I am using that contains picture boxes, Once emailed many of my colleagues are unable to upload a picture, the image with the picture and monitor in front is not visible. Any suggestions? Kind regards.
This is so helpful. Please how can I get the sample excel sheet so I can practice?
I loved your video and presentation and found a few things I needed to change. However, my calculated field is still not working. I've tried everything I can think of but no luck. Any other ideas?
What if I don't have an option for "Format" under the Text Field Properties?
Dear Sharon I have reviewed most of your tutorials, which are excellent, and I have learned a lot and successfully applied it. However, I havenât found (or maybe I didnât recognize) what I currently need: I have to create a PDF form for a report from a site visit where some installation works will take place. So, our employee arrives at the address with a tablet (the tablet is online, equipped with a camera and stylus), Before he starts site visit, he will download, using the tablet, a pre-prepared form for each location he visits, which already includes basic information about the location, client name, address, contract number, etc. At the site, he only needs to fill in a few additional fields in the usual text boxes, but I I canât reach a solution for a few more fields: 1. The layout of the location is a pre-inserted image in the form. Our employee needs to mark several points on this image with the stylus, draw a few lines, and enter some numbers, so that this remains recorded on a layer above the image. 2. There should be an option to insert a photos taken on-site at several designated positions: the idea is that he clicks in the form to initiate the tabletâs camera and immediately inserts the taken photo into the document. Alternatively, he should be able to insert a photo from the tabletâs gallery. After that, he should also be able to draw several lines and enter a few numbers over the inserted photo (as in point 1). 3. At the end of the report, there should be a field for the clientâs signature. When our employee finishes the site visit, he presents the report to the client and offers him/her to sign on the tabletâs display with a finger or stylus. So, NOT a digital signature or certificate, but a handwritten signature. I would appreciate it if you could give me advice on how to create fields for these 3 points. Or even better, if you could create a PDF form with these 3 elements (design and field positions are irrelevant) and send it to me. Thank you in advance.
This is amazing. I have used it for my inventory and am now using it to help me format some other docs. Thank You soooo much.
That is awesome! Iâm so glad to hear this template has helped you! Thanks so much for watching my videos and taking time to leave a nice comment!
Hi. really helpful video. thankyou. yt doesn't have the save option for this though. ?
OMG... thank you so much... I have spent hours looking for this solution and I finally found it!!!
Iâm so glad you found my videos and that they helped you out! Thanks for watching!
Not sure if you monitor this video for comments but I canât find any instructional videos for comparing two columns to find a matching name IN A TEXT STRING. Ie one cell may be Mr. John smith in one column and John Smith , Mr. in the second column. I want to be able to match the name Smith. Thank you. I do find your explanation easy to understand so Iâm hoping you have a simple solution
This is one of the best excel inventory videos I've come across. I am subscribing to form part of your inventory of subscribers..lol. I love the video please keep making more
đ Thank you so much for subscribing to my Channel and for watching my videos! Iâm so glad you found this video and template helpful! Best of luck to you!
While selecting the options from the dropdown list, I accidently selected one entry which shouldn't be there. But now, I'm unable to delete it without removing all the other selections with it. What to do in such a case?
Thank You for this!
Glad you found it helpful! Thanks for watching!
I wish you the best You are a life saver thanks a lot Sharon
Thank you so much for watching my videos! Glad you find them helpful!
Superwoman!!!!!
Thanks for watching!!
Your presentation and communication skills are tope tier! Thank you for the time investment and for sharing.
Thank you so much for leaving such a nice comment! Iâm glad you found my videos helpful!
Your videos are so well done. Very detailed but very easy to follow along to. Thank you so much!
Iâm so glad you find my videos helpful! Thanks for the nice comment and for watching my videos!
Sharon I have many quiz to ask u
Thanks for watching! Let me know if you have any questions.
Great information and video! Thank you Sharon!
Glad you found it helpful!! Thanks so much for watching!
Hi Sharon Smith I need your help! Is it to possible Populate one field with the data from three different fields. So that data can be copied and pasted as a group of data for use in a File Name. This comes from the use of a Service Report in order to be consistent in File Names.
This is a great video! One question: Is there any way to auto populate form fields without restricting editing? I am working on a Microsoft Word Document that that is more "essay like", rather than a typical fillable form. In other words, it's continuous text with paragraphs, etc. The document has multiple fields where I want to insert "name", or ther such fields, but I don't want to restrict editing of the rest of the document. Can this be done?
Here is the conditional formatting formula used in this video that references the specific cells in this semi-monthly timesheet template: =OR(AND(DAY($C$10)=1, DAY($C10)>15), AND(DAY($C$10)=16, MONTH($C10)<>MONTH($C$10))) Save time and purchase these templates and you'll get the Semi-Monthly, Bi-Weekly and Weekly timesheet templates with all the formulas and formatting for $10. This helps support my channel so I can continue to make more videos for you all. Thanks so much for watching! Here is the link to my Etsy listing: www.etsy.com/listing/1745072850/employee-timesheet-template-for-payroll
nice
Thanks for watching!
Thank you for a fantastic educational video! Simple and concise! You are awesome.
Thanks so much for watching! Glad you liked it!
Great instruction. I do have a question on the conditioning formula how do you know what to enter? I copied your formula and it's not working.
She stated in the video that you need to buy the template from her online site if you want to get the entire formula.
@@skjones91199 I thought the screenshot showed the formula. I figured part of it is cut off when it wasn't working.
Hello, here is the full conditional formatting formula you may be looking for: =OR(AND(DAY($C$10)=1, DAY($C10)>15), AND(DAY($C$10)=16, MONTH($C10)<>MONTH($C$10))) This works with the timesheet template and cell references from this video. Hope this helps. Thanks for watching!
Thanks for replying to this comment! I shared the entire conditional formatting formula in the pinned comments. It will work for the cell references in this particular timesheet template. Thanks for watching!
@@SharonSmith thank you. You're videos have been so helpful. I did end up purchasing the templetes to save tiem. I am taking it a step further and adding the meal in/out.