Skip to main content
Solved

IF Then Statement for Empty vs Non-Empty Fields

Hi all!

I’m looking to create a formula along the lines of:

If Field(Dropbox Link) is Empty and Field(Review Link) is NOT Empty THEN mark the status as “ :x: Incomplete :x: ”

If Field(Dropbox Link) is NOT Empty and Field(Review Link) is NOT Empty THEN mark the status as " :white_check_mark: COMPLETE :white_check_mark: "

If Field(Dropbox Link) is NOT Empty and Field(Review Link) is Empty THEN mark the status as :white_check_mark: COMPLETE :white_check_mark: "

If Field(Dropbox Link) is Empty and Field(Review Link) is Empty THEN mark the status as “ :x: Incomplete:x:”

I’ve tried IF({Dropbox Link} =BLANK(), “ :x: Incomplete​:x:” ) which works, but when adding anything onto that, I hit a wall!

Would really appreciate some clarity on this if possible!

Best answer by Jeremy_Oglesby

Hi @Ali_Shannon - welcome to the forums.

It looks like your only real condition there is that if {Dropbox Link} is NOT EMPTY, then it is COMPLETE. In any other case (regardless of the status of {Review Link}), you want it marked INCOMPLETE.

If that’s an accurate description of what you want, try this:

IF(
   {Dropbox Link},
   "✅ COMPLETE ✅",
   "❌ Incomplete ❌"
)

But if your conditions are actually more complex than that, or if I’m misunderstanding, post back with what you are actually looking for.

View original
This topic has been closed for replies.

2 replies

Forum|alt.badge.img+18

Hi @Ali_Shannon - welcome to the forums.

It looks like your only real condition there is that if {Dropbox Link} is NOT EMPTY, then it is COMPLETE. In any other case (regardless of the status of {Review Link}), you want it marked INCOMPLETE.

If that’s an accurate description of what you want, try this:

IF(
   {Dropbox Link},
   "✅ COMPLETE ✅",
   "❌ Incomplete ❌"
)

But if your conditions are actually more complex than that, or if I’m misunderstanding, post back with what you are actually looking for.

    • Ali_Shannon
    • Author
    • New Participant
    • March 4, 2021

    Hi @Ali_Shannon - welcome to the forums.

    It looks like your only real condition there is that if {Dropbox Link} is NOT EMPTY, then it is COMPLETE. In any other case (regardless of the status of {Review Link}), you want it marked INCOMPLETE.

    If that’s an accurate description of what you want, try this:

    IF(
   {Dropbox Link},
   "✅ COMPLETE ✅",
   "❌ Incomplete ❌"
)

    But if your conditions are actually more complex than that, or if I’m misunderstanding, post back with what you are actually looking for.


    Hi Jeremy, thank you so much - I think you’re right and that formula will cover what I needed, really appreciate you clearing that up for me!!

      Terms & ConditionsAccessibility statement