Adding Sort to a Text Mode Report Column

[ThomasNe2]

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

[Sven-iX · Accepted solution]

Hi @ThomasNe2 

You cannot sort on a field like this. It's dynamically evaluated. (See various posts here, e.g. this one).
You can put this expression into a calculated field. Then in the report can be sorted by it.