Skip to main content

Confirm Date Field is Populated


Forum|alt.badge.img+4

I’m sure this is easy, but I’m stumped for the moment…

I need a formula that can confirm that an adjacent date field has been populated and is not empty.

IF({Timestamp}>0,“ :white_check_mark: ”,"") isn’t working…

I’d just like a check if when we enter a date. I’m sure I’m missing something. Thanks!

5 replies

Forum|alt.badge.img+4
  • Author
  • Known Participant
  • 162 replies
  • June 20, 2018

P.S. This is the inverse of our need here… Timestamp for when checkbox has been checked


Forum|alt.badge.img+18
Andrew_Enright wrote:

P.S. This is the inverse of our need here… Timestamp for when checkbox has been checked


The absence of a value in a field is a “falsey” attribute, meaning it will evaluate as false in a conditional statement.

The presence of a value (any value) is a “truthy” value, meaning it will evaluate as true in a conditional statement.

The implication of that is that you can just drop the > 0 From your formula if all you need to check for is the presence of a value.


Forum|alt.badge.img+4
  • Author
  • Known Participant
  • 162 replies
  • June 22, 2018
Jeremy_Oglesby wrote:

The absence of a value in a field is a “falsey” attribute, meaning it will evaluate as false in a conditional statement.

The presence of a value (any value) is a “truthy” value, meaning it will evaluate as true in a conditional statement.

The implication of that is that you can just drop the > 0 From your formula if all you need to check for is the presence of a value.


Sorry, IF({Timestamp},":white_check_mark:","") doesnt work… I dropped the >0, but no dice. What am I missing?


Forum|alt.badge.img+18
Andrew_Enright wrote:

Sorry, IF({Timestamp},":white_check_mark:","") doesnt work… I dropped the >0, but no dice. What am I missing?



Forum|alt.badge.img+4
  • Author
  • Known Participant
  • 162 replies
  • June 22, 2018

Got it! Thank you!

Sometimes the simplest things elude you.


Reply