The formula for a calc column IF statement
=if([field]=””, “No”,”Yes”)
Watch for the formatting of the quote marks
This says:
IF the field that you want to check is empty (“”)
THEN populate with No (“No”)
ELSE populate with Yes (“Yes”)
=if([field]=””, “No”,”Yes”)
Watch for the formatting of the quote marks
This says:
IF the field that you want to check is empty (“”)
THEN populate with No (“No”)
ELSE populate with Yes (“Yes”)