I’m not sure if this is possible. First off, field formulas can’t do self-examination (i.e. “Am I empty?”). They can only examine/collect the contents of other fields for processing. Second, a field can only be one type, and can’t change from being dynamic (i.e. formula-driven) to static once it fills with data.
If I’m wrong about any of this, I’m open to correction, but this is my current understanding of how the system operates.