Видео

Thank you for your order, and I'm happy to help! You can update the class type in column G as well as column X. When you mark an assignment as Done (check the box), also change the Status column (H) to completed and this will update your dashboard. If you have any other questions, I'm happy to help!

Thank you for your order, and I'm happy to help! The two Gantt Charts work independently from each other. Typically users prefer one or the other. I'm happy to help you add more project phases as well! I'll send you a direct message on Etsy.

@@hermionegranger9996 This is the tutorial for how to use the tracker and it’s available for purchase!

Hi Nicole, thanks for your order! You will select the row you would like to delete on the Project Tracking tab and delete it there first. Then you will also delete that same row on the Gantt V1 and Gantt V2 tabs.

Great question! Using the Project Week drop down is a good way to have a monthly or quarterly view of your project

@@dressedinjoy thanks! but i might be missing something. I tried this already and changing the project week in the drop down simply changes which week of the year the gantt chart begins displaying, it doesn't seem to change the interval by which the gantt chart displays. does that make sense? is there another adjustment I need to make to change the interval of time between columns in the gantt chart?

@@ryanhashemi_ yes that makes sense. At this time the Gantt chart is displayed in weeks rather than another time interval, so using the project week menu allows for a “monthly” or “quarterly” view by changing when the Gantt chart starts

What is the trouble? I’m happy to help!

Absolutely! Here you go: www.etsy.com/listing/1533887204/assignment-tracker-google-sheets-student

Thank you for this feedback-great ideas!

I’m not sure I understand your question. Which specific rows and columns in the template would you like to highlight?

@@dressedinjoy lets assume end date is 1/8/2023 and today is 4/8/2023 in Gantt Chart calendar i want to highlight from day 1/8 to 4/8 as a warning for late task ( i want it auto highlight everyday )

Thank you for clarifying! I would use the second sheet “Detailed View” and add your task start and end dates. I would then add 0% to the percentage complete column to show the task was never completed. This will change that column to white and will easily stand out from other tasks

@@dressedinjoy i did it without touching the percentage done in the chart :) thank you for trying help :)