The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Jun 19, 2018 07:10 PM
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!
Jun 19, 2018 07:14 PM
P.S. This is the inverse of our need here… Timestamp for when checkbox has been checked
Jun 19, 2018 07:24 PM
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.
Jun 22, 2018 12:47 PM
Sorry, IF({Timestamp},":white_check_mark:","")
doesnt work… I dropped the >0
, but no dice. What am I missing?
Jun 22, 2018 12:49 PM
Jun 22, 2018 02:32 PM
Got it! Thank you!
Sometimes the simplest things elude you.