Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 23, 2022 08:49 AM
Hello everyone,
I am having an issue with a pretty simple if statement with !=blank():
If({Date}=blank(), “Blank”, “Not blank”) - this returns “Blank” if the field is blank and “Not blank” if there is something is entered - as it should
If({Date}!=blank(), “Blank”, “Not blank”) - this returns “Blank” no matter if the field is empty or not
Am I missing something?
Thanks,
Jordan
Solved! Go to Solution.
Jun 23, 2022 10:31 AM
Just use your date field by itself in the IF
function.
IF(
{Date},
"There is a date",
"No date"
)
This works for all editable field types except for number fields that could be zero.
Jun 23, 2022 09:46 AM
BLANK() is used for other purposes. Just compare your Date field to ""
:
{Date}=""
Jun 23, 2022 10:31 AM
Just use your date field by itself in the IF
function.
IF(
{Date},
"There is a date",
"No date"
)
This works for all editable field types except for number fields that could be zero.
Jun 23, 2022 12:55 PM
Thank you both, I had implemented a work around but those are both much simpler!