I have a document library for storing presentations. About 10 new ones each week. I created a calendar view for the library.
We have five different series of weekly meetings, abbreviated as GR, MR, NC, etc. The GR meeting is always at 8:30 am, MR is always at 8:15, NC at 12 noon, etc.
Using a calculated column, the title displayed on the calendar concatenates the data from 4 columns. The series abbreviation is one of these four.
When adding documents to the library, I would like to code the date field's display so that if the series = GR, the time automatically = 8:30, if the series is MR the time always = 8:15, etc.
Is this something that can be done via a calculated value in a date field? If so -- how?
Thanks so much!
John