Is there a way to change a field type based on data in another field? My app tracks performance on service level agreements, and the metric can be either a percentage, a time in seconds or a number...
You cannot change a field type by formula. One solution is to have it be a text field but calculate a text result which appears to be a number or a percent.