I want to add a new ranking column, which automatically ranks all the date/time values from the 'Timestamp' CalcField from oldest to newest (e.g. 03/03/2019 14:00 = "1"... 02/09/2019 12:00 = "10"). Manually entering this data is not an option.
I have not been able to find any SharePoint Online solution for this, so I am open to non-conventional/creative methods - preferably not too 'coding-heavy'.
Where there are (for example) 5 spaces on the course, students with a ranking between 1 and 5 will automatically enrol onto the course, whilst the remainder will be reserves. I have replicated the scenario successfully using dummy-data in Excel - see below.
Following this, I will set up a workflow that will send out email notifications.