I’m building a master calendar that shows scheduled jobs from several departments, each living in its own solution. I need the events to be highlighted/coloured based on a specific field (in my case field team), so I can’t just overlay several calendars using the multiple-calendar option in the calendar view settings. That option doesn’t give me the colour-coding and sorting I need across sources. What I’ve tried and why it falls short: Automation creates a duplicate record in a central calendar table, with a lookup field pulling in the date and the field the highlighting depends on. The source date field is a date range, and a lookup of a date range doesn’t show up on the calendar view. Copy the source date range into a real date range field on the central table when the record is created. This displays correctly, but the date is now stored in two places. If someone edits the range in only one record, the two get out of sync, and for scheduling jobs that’s too risky. Formula to convert a looked-up date range into a true date range field. I couldn’t find one. My questions: • Is there a way to make a lookup of a date range display on a calendar view that I’m missing? • Is there a formula or other method to turn a looked-up date range into a real date range field, so the source stays the single point of truth? • Is there a better pattern for pulling records from multiple solutions into one calendar with conditional colouring? • If none of this is possible today, I’d like to suggest it as a feature request: either support for lookup date ranges in calendar views, or colour-coding across multiple overlaid calendars. Thanks in advance.