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

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

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

Thanks!

This topic has been closed for replies.

+27

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.

Sign up