IF blank, add date


I’m trying to solve a problem that I think may not be all that complicated. I want to automatically add the date to a column if the column is blank (ideally so that dates answered previously don’t change but new entries have the date added).

Anyone have any formula suggestions?


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.