Skip to main content

IF blank, add date

  • November 21, 2017
  • 1 reply
  • 20 views

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?

This topic has been closed for replies.

1 reply

Justin_Barrett
Forum|alt.badge.img+21

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.