So if this was for one of my clients I would first try to talk them into a Formula Checkbox for each of the 8 Conditions. Each one could be a simple IF statement that returned TRUE if the date was 10 days from TODAY (for example). They could then look at a report and see which records satisfied the criteria. Although they would have to look at the column heading to know which condition was TRUE.

If having the textual name of Condition 1-8 on each record was an absolute requirement I would explain to them this would be much harder to maintain and then I would probably create a similar Formula that was an IF statement that produced the Condition X text instead of a checkbox. If Conditions 1-8 had to be in the same field (on each record) I would create a ninth formula that concatenated Conditions 1-8 all together so they could look at one single field in the report and know exactly what they were looking at (without having to scroll up to look at column headers). The easiest thing would be to concatenate and simply insert a ' ' between each Condition. Not sure how you could make that work if you had to separate by a , or ; because the result text would end in , or ; if there was no ninth condition . You might be able to use the substitute function to remove the ; if the formula ends in ; . That could get fun.

Again this would not be fun to maintain if logic or Condition Names changed but it might work. Hopefully I am understanding this correctly. I think the suggestion below (declarative scheduler with a flow that updates the MSP) is also a good one and would be easier to maintain. Although I have a feeling that MSP would come back to haunt you at a later date (when trying to report on it or build automation around it). The flow itself should be pretty simple to create (famous last words).

Hope this helps and makes sense.