Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Topic Labels: Formulas
105 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Reply 1

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.