IF condition

[tmahmo15]

How can I make this statement work:

[JosephSerpis · Accepted solution]

Hi @tmahmo15 your contains in the formula should be this Contains([OS Name], "Windows") you need to specify the string field and the target to search for. The Syntax should be this

If [OS Family]= " " and Contains([OS Name], "Windows") then "Windows" 
Else [OS Family]
Endif

  an Improvement on the IF might be as the IsEmpty functuion searches for nulls and empty in a field

If Isempty([OS Family]) and Contains([OS Name], "Windows") then "Windows" 
Else [OS Family]
Endif

[atcodedog05]

Hi @tmahmo15 

Change the formula to below

IF [OS Family]=" " and Contains([OS Name], "WINDOWS") 
THEN "WINDOWS" 
ELSE [OS Family] ENDIF

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[tmahmo15]

Thanks a lot!