Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is my calculated field formula
IF(WildMatch([State],'* *',[Title],'*Mr*'),'Unknown',)
If the field State is blank with no data and the field Title is ‘Mr’ then I want the calculated field to display ‘Unknown’ for that record. I don’t think I have the correct syntax for the blank field with no data, can you help?
Hi, Boon, you have to use wildmatch() for every field. So, it would be
If(WildMatch([State], '* *') and WildMatch([Title], '*Mr*'), 'Unknown')
But as for blank values, i'd do it differently
If(len([State]) = 0 and WildMatch([Title], '*Mr*'), 'Unknown')
Hi, Boon, you have to use wildmatch() for every field. So, it would be
If(WildMatch([State], '* *') and WildMatch([Title], '*Mr*'), 'Unknown')
But as for blank values, i'd do it differently
If(len([State]) = 0 and WildMatch([Title], '*Mr*'), 'Unknown')