Yes, India passport holders need a valid visa to visit the Colombia for tourism purposes. You must be outside Colombia when you apply for the tourist visa. Also, you cannot work in Colombia with the tourist visa.
Indian Citizens can apply for an e-visa prior to their visit, which is a convenient and efficient way to obtain the necessary travel authorisation without visiting an embassy or consulate.