I created a text column, the value of which is used in 43 formula columns. I would like to change this column to either number or status, because text columns cannot be used in automations.
When I change the column type, all references in the formulas are lost and redirect to the (then) deleted text column. Thus, I’d have to manually change all 43 formula columns. That’s just way too big a pain!
Is there a workaround?