I know that something like this would be possible by creating two columns, one for the raw data and one for a formula to transform the data. That being said, it would be great to be able to create a “Transformation Field” that would operate similarly to a Function field.
The function would receive the cell data directly, and transform it into the desired formatting for the cell. For example, you could paste in a URL that would then be run through a REGEX function to strip away everything except the root domain itself.
