Yes you can do this through another app called RS Alert that can send SMS based on a workflow event.  Read about the RS Alert app here