Select Value using if not blank but only show values that are in the same row.

AppSheet AppSheet Q&A
, , , , , , , ,
1

Hello,

Little lost here. Wondering if someone could help me out.

I have this formula which works great but I have manually select the values I want as it show the whole column. Is there away where this formal can modified to auto select the values that matches.

Here is the formal I working on. SELECT(equipment[Unit],NOT(ISBLANK([Type of filter])))

Screen Shot 2022-10-02 at 8.39.21 AM.png
Screen Shot 2022-10-02 at 8.39.21 AM.png1434Ă—472 58.5 KB

Screen Shot 2022-10-02 at 3.48.38 PM.png
Screen Shot 2022-10-02 at 3.48.38 PM.png372Ă—646 48.3 KB

2

I don’t clearly understand what you’re trying to accomplish. Maybe the SWITCH function would help you. For example:

SELECT(equipment[Unit],NOT(ISBLANK(
SWITCH([Type of filter], 
"Engine Oil Filter", [Engine Oil Filter], 
"Fuel Filter", [Fuel Filter], 
...
)
)))
1 Like
3

Hello,

On a earlier post “Can you use a dropdown list in a select formula”,WillowMobileSys helped me that when I used my dropdown on “type of filter” that “parts number” value would show the filters that associated with the type of filter. Now what I like to have is once those two are enter that my “unit” value will automatically show the units (equipment) that uses that filter.

I just can’t grasp the formula to do that using the select with multiple condition only if the part number value is not blank.

Thank you in advance