If a property has a value return Yes to a separate property

[Adam_Sharrow]

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!

[Kamille_Parks]

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.