Hello everyone. I was facing an issue while a making a saved search. I have a list/record field on my transaction record and I want to get the records on which that field is empty. Currently when I select the field in filter tab it only allows me to change from "any of" or "none of". how can I check if the field is empty or not?

If you don't have have an option to do any of - None - then you could probably use a formula e.g.

CASE WHEN {field} IS NULL THEN 1 ELSE 0 END

is equal to 1

If you select the double arrow to bring up the list on the criteria, the first selection should say "is empty".

@Zareen Thanks, that worked perfectly. I had used this before but I don't know why this time I couldn't remember it. But Thanks alot.