IF blank, add date


#1

Hello,
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?


#2

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.