Skip to main content

I would like to create a property on my table that returns a value of “Yes” if another property on the table has any value in the cell

Think it’s a fairly easy IF statement but am struggling to complete.

Property Names

  • Added to Website
  • Website Link

IF(Website Link is known) THEN add text to Added to Website = “Yes”)

Thanks!

Your {Added to Website} field would be a formula like this:

IF({Website Link}, "Yes", "No")

the , "No" bit is optional if you just want Yes or blank values for that cell.