Skip to main content

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 “ ❌ Incomplete ❌ ”


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


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


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


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


Would really appreciate some clarity on this if possible!

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 @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!!

Reply


Terms & Conditions