Love using Ragic.
I want to make a job schedule for a industrial painting company.
Each job has one color allocated to it and they sequence jobs by going from light colors to dark colors then back to light colors and so on.
They process 30-40 jobs a day and there are approx 50 colors in the range.
I have used a pivot table report to show the jobs in a calendar but can only get it to go from light to dark colors
Do you have any suggestions on how I could achieve a light to dark to light schedule?