Date isn't showing on calander

Connie Cochran

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.

Paul Newcome

The JOIN function outputs a text string, so you are not storing any dates in that column. You would need to use an INDEX function most likely.

Connie Cochran

Thank you for your help.

I'm not familiar with index. How would I write it? Currently I have =JOIN([Approved screening date]@row, "")

Paul Newcome

If all you are doing is a straight cell reference, then you don't need any function at all.

=[Approved screening date]@row

Connie Cochran

Awesome!! Some times its the simple things that trip us up the most. You have been a tremendous help!

Paul Newcome

Happy to help. 👍️