Help

IF blank, add date

Topic Labels: Formulas
1870 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Darryl_Holliday
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Reply 1

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.