Help

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

Topic Labels: Formulas
365 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Adam_Sharrow
4 - Data Explorer
4 - Data Explorer

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.