We love using it, and have added a number of milestones automatically so far. Here's a few examples:
- Orig contract
- Go Live
- Transition to support
- Reference call made
Here's the short wish list for your consideration:
1) Date range - I'd love to be able to add the milestone when a certain date field is populated. At this point, the source object related fields are still updated manually, and therefore sometimes it takes a few days before we know that the customer had been live for the past 7 days. A possible solution would be to create a criteria where go live date is equal or less than 7 days from rule date, however... sometimes it's more than 7 days, and it would be great if we could just say - is not null and less than rule date.
2) Post update comments - We already are able to add comments to the milestone. However, when we have the rule run twice (or apply a date range as described in #1), the comments appear twice. Bottom line, it would be great if we could indicate that we only want the comments to update "Once".
3) Post to chatter - Not every milestone calls for an action. However, sometimes, it makes sense to notify the milestone on chatter. It would be great if this capability would be turned on for milestones, as it is currently available only for CTA.
4) Date comparison - another useful situation is to simply compare one date to another. For example, I may want the "Go Live" date to create a milestone only when it is greater than another date field in the account object.