Google Sheets =Query() Contains & Or & And
Вставка
- Опубліковано 25 сер 2024
- A short video that shows you how to use Contains, Or, And in your Queries.
-- Affiliate Links --
If you would like to create UA-cam Videos I highly recommend using TubeBuddy www.tubebuddy....
Hello, Joe! Just discovered you. Excited to learn from you.
I’m struggling to find a solution to my google sheet conflict and hoping maybe you can help…? 🙏🏼
I have an inventory dashboard tab I’m trying to build in a sheet and setup two query formulas to pull data into the dashboard from two other tabs of inventory. I’m I’ve got the two query formulas as a ={;}, which works fine by itself. But for some reason when I try to integrate drop-down menu filters to the dashboard query array, I can’t seem to get it to work and have also gotten the array literal error a few times. Can’t seem to find a solution.. is this something you might know how to resolve..?
Thanks!
- jared
Hi Jared. Thank you for the question. Here's what I want you to do. In your sheet go to File -> Make a Copy. Then in the copy delete all the tabs that are not a part of this question. Then remove all personal and confidential data. If that includes the items in your inventory please replace that with some dummy data that will replicate the real stuff. Then go to Insert -> Drawing and use the text box and place your question in there. You can reference cells where you need help and where data is coming from. Then share the link here. I'll make a video answering your question.
@@josephcambron8927 Hi, Joseph! I'm not sure if you received my comment with the link. I know sometimes a UA-cam account is set to not allow comments that include URLs... Let me know if you still need it or if I can directly send it via email or otherwise. Thank you!
I did not see your other post. Must be the url. Please email me at josephcambrontutorial at. gmail.com
@@josephcambron8927Got it! Thank you; just sent an email to you