Solved
Adding Sort to a Text Mode Report Column
I am using the below to pull some data into a Task report from data on the Project custom form. This was previously in a calculated field but as I need this data to be readily refreshed, without being prompted, I have moved it to the column. What I am now unable to do is sort or group on this data. I tried adding a line for sorting but it hasn't worked. Does anyone know what could get this working?
displayname=Bet Content Task - Start Time & Date
valueexpression=IF(CONTAINS("1",{name}),{project}.{DE:UKI - Bet Offer 1 Banner Live Start Date & Time},IF(CONTAINS("2",{name}),{project}.{DE:UKI - Bet Offer 2 Banner Live Start Date & Time},IF(CONTAINS("3",{name}),{project}.{DE:UKI - Bet offer 3 Banner Live Start Date and Time}, IF(CONTAINS("4",{name}),{project}.{DE:UKI - Bet Offer 4 Banner Live Start Date & Time}, IF(CONTAINS("5",{name}),{project}.{DE:UKI - Bet Offer 5 Banner Live Date & Time}, IF(CONTAINS("6",{name}),{project}.{DE:UKI - Bet Offer 6 Banner Live Start Date & Time}, IF(CONTAINS("7",{name}),{project}.{DE:UKI - Bet Offer 7 Banner Live Date & Time}, IF(CONTAINS("8",{name}),{project}.{DE:UKI - Bet Offer 8 Banner Live Date & Time}, IF(CONTAINS("9",{name}),{project}.{DE:UKI - Bet Offer 9 Banner Live Date & Time}, "")))))))))
valueformat=longAtDate
