Cluster the original table on ( CreatedDate, SmsId ), in that order, not vice-versa.

Once you get the best clustering key, you're likely not to need partitioning yet. And, if and when you do, the clustering key will already match your partitioning key.