Date isn't showing on calander

Connie Cochran
Connie Cochran ✭✭✭✭
edited 04/21/23 in Add Ons and Integrations

The date field that I am using for my calendar is a formula referencing another field but its not showing up. The property is set to date. Any idea why?

Background; I have one sheet with multiple dates in a row. I created a separate sheet for each column with a unique first field containing a =join function to pull the date from the column I am looking at for that sheet. Then in report view I merged all of the sheets to look at the unique first field dates.

Really struggling to create a calendar that has multiple dates for the same row. My dates aren't consecutive so I can't use the through option.