Was hoping someone could assist with a formula issue. I have a gallery that is being filtered at the moment except I need to add another filter for a column that has blank value. i only need data where processquote2="2" and team2<>"" (Where process quote 2 is equal to "2" and team2 is not equal to "<blank>".
This is what I have at the moment, but it doesnt seem to work:
1. Sort(Filter('Request For Quote',ProcessQuote2="1",Team2<>""),Title, Descending) - Doesnt work at all
2. Sort(Filter('Request For Quote',(IsBlank(Team2)&&ProcessQuote2="1")),Title, Descending) - Works the opposite way, brings them in team2 is blank whereas needs to be hidden