I'm trying to figure out how to identify 'if' a list of items in one cell contains a value or string. EXAMPLECell A1 contains sites, sheets, docs, slides. I want cell B1 to display a 1 'if' cell A1 contains the string sites.FORMULA=if(A1 ?????? sites, 1,0)I'm not sure what to replace the ?????? with in the above formula OR if this formula is possible. Any ideas on how to accomplish the desired outcome is greatly appreciated. 
Google Sheets formula for if contains
google spreadsheets;formulas
You can use regexextract:=IF(ISTEXT(REGEXEXTRACT(A1, sites)), 1,0)To explain regexextract allows you to see if that word appears in your string.  However by default if the string is not found it returns #n/a , therefore i chose to wrap that formula with istext. This will only return true if the string is found. 