Date isn't showing on calander
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.
Answers
-
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.
-
Thank you for your help.
I'm not familiar with index. How would I write it? Currently I have =JOIN([Approved screening date]@row, "")
-
If all you are doing is a straight cell reference, then you don't need any function at all.
=[Approved screening date]@row
-
Awesome!! Some times its the simple things that trip us up the most. You have been a tremendous help!
-
Happy to help. 👍️
