Please help with automation
I am creating a sheet that will be used to collect data from multiple departments. The data then needs to be rolled up to individual calendars to reflect stats by name and then the data from individual calendars will need to be rolled up into one collaborative calendar and reflect 'if this' data by colour.
I am stuck!
This project will be used nationally, within my organization, to reflect employee coverage at any given time. The first level calendar will show approved time off, reflected by names, to be viewed by leaders of a region. The next level calendar will show a collaboration of all regions but, rather than by name, it will need to reflect coverage by colour (20< away = red. 10 - 19 away = yellow. 10> = green.
Please provide any guidance you can to help me work out the automation and select the best calendar view.
Thank you in advance for your help!
Help Article Resources
Check out the Formula Handbook template!