This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

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

Posted on 10-02-2022 02:49 PM
Jpaulsen
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

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.pngScreen Shot 2022-10-02 at 3.48.38 PM.png

0 2 937
0 Likes
2 REPLIES 2
Top Labels in this Space