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
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 😀👍
Thanks a lot!