Create a meeting agenda based on requests adding an agenda timeslot

[KariB93WI]

We have a meeting every week to discuss new photo and video projects with our studio team. We'd like use a WF report to automate creation of the agenda. I have a report that filters the requests and shows the needed data. I'd like to add a timeslot as a column in the report. 

The first request entered each week should be assigned a 1pm timeslot. Each request after that is assigned the next timeslot in 15 minute increments. I am pretty good with report text mode and calculated fields. Has anyone done that before? 

[skyehansen · Accepted solution]

there's no way to automatically assign time slots for requests. The closest you could get would be to organize them by ref ID in ascending order, and then manually input a time based on a dropdown.