Simple IF Statement not working. Help

Trying to workaround the fact that can’t do both OR and AND filters by using an IF statement. This is just the beginning but I can’t get it to throw the correct result. Suspicious it is because it doesn’t work for Fields that are linked to other tables, but not sure why it wouldn’t. Am I missing something else? Perhaps because it is a string? It seems like a really easy IF statement, but it throws “No” when it should throw “reponsible”). Help!

If this can’t be fixed perhaps you have other ideas for how I can show only those entries for which a specific entity is either responsible or accountable (ideally with the ability to group by which they are)/

Hi @Rebecca_Niles - your formula should work - maybe there’s an additional character in the linked field that isn’t in the formula?

I did a similar thing here:

The two formulas both work with a single linked field.

Formula 1 is:

IF(Person = 'Jim', 'Yes', 'No')

Formula 2 is:

IF(FIND('Jim', Person), 'Yes', 'No')

The difference is that Formula 2 will work if more than one record is linked:

1 Like

Yes. So simple. I should have figured that out. Had removed the space BETWEEN the words but not checked for an errant space after. Thank you!!! Thought I was going crazy.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.