sheets | Interact with CSV files as Python objects | CSV Processing library

I've been trying to build a small database with Google Sheets for me, my wife, my friend and his partner, to make it quick and easy to search through our recipes from HelloFresh!

I've input all of the recipes, and I am able to query to show recipes we would like based on which meat/vegetable, and what main ingredient (pasta, rice etc).

The next thing I would like to do is have a list generate/filter based on what ingredients we have, in this case cells J6:J13. I would like the list to generate if any criteria is met. For example, if both Chicken Thigh and Beef Mince are selected, it will show all recipes that have chicken OR beef.

Would anyone be able to assist, please?

https://docs.google.com/spreadsheets/d/19Nrr5NurZ5SkLYYPg09dl_XJMe2gx7Ft2TFO4yNklKY/edit?usp=sharing

Sorry I don't show my variables or anything, tried to give information only pertaining to the questions. This 1 Sub is huge.

Currently my code allows a user to select multiple files, the files selected will be sorted in a specific format, then loaded into 2 different arrays. Currently loads Columns D:E into 1 array and Columns I:K into another array (from selected files QSResultFileWS, and returns those arrays to my destination FormattingWS. I'm still trying to learn arrays so if the methodology I used to do this isn't proper, be gentle.

The following code does everything I want: pulls email, saves attachments, extracts files EXCEPT save the original email to the folder fDest. I seem unable to see the solution.

This seems to be the problematic line as it won't save the email: "mi.SaveAs fDest2, olMSG"

I have been trying to sort the Column values from A to Z which are populated in the List Box.

I have tried with the following but it does not adjust it. Any help will be appreciated.

I have two google sheets in the same workbook and I am trying to import certain columns from one into the other sheet based on what hour of class was chosen. For example, I have the Date in column A, Name in B, Email in C, and Number in D and other stuff, then the Class in I.

Column A - Date Column B - Name Column C - Email Column D - Number ... Column I - Class

My goal is to import column B through D if column I has a certain class. I tried a using this if statemnt: =if('Confirmação'!I2 = A1,(=importrange("sheet_url","Confirmação!B2:D2")), "NOPE") where A1 has the name of the class to look for, but it resulted in a #Error.

Then I tried a variety of query such as the following: =QUERY({'Confirmação'!B2:D2,'Confirmação'!I2},"Where I = 'Terça 19h English 1'") =QUERY({'Confirmação'!B2:D2, 'Confirmação'!I2},"Where 'Confirmação'!I = 'Terça 19h English 1'")

and also added the IfError: =iferror(QUERY('Confirmação'!B4:I4,"Where I = 'Terça 19h English 1'"),"Vaga")

Could someone correct my functions or help with a google script? Thank you! Very much appreciated! (Sorry about the Portugues-it's a project I am working on in Brazil)

I have this situation on google sheets

image

I wanted to make a monthly report with sumifs with 2 conditions like the image above. But all I got was errors.

Code I am using

=sumifs(D2:D13;D1:G1;C16;B2:B13;or(B2:B13="apple","cherry","watermelon"))

I have some JSON data in Google Sheets that I wish to parse for the data after a keyword, eg:

"splashtopname":"DESKTOP-XXYYZZ"

This is in the middle of the JSON data which is delimited by commas eg:

"cpuidentifier":"Intel64 Family 6 Model 92 Stepping 9","splashtopname":"DESKTOP-XXYYZZ","splashtopversion":"3.4.6.2",

What I want to do is extract DESKTOP-XXYYZZ only from this (however this string length is variable and not fixed, nor does it always begin DESKTOP). I am stumped as to the formula to get this output, so any help would be greatly appreciated.

Thanks in advance!

I have tried to write the vba code for inserting and changing the image inside the user form in excel but I was not able to insert as well as to change the image based on the combo box, To insert the value in combo box I have added the row source as shown in the image ( List of fruits) and to insert the images I have kept in particular folder which you can find in my program.

pl. can anybody correct me in this program or help me to get this solved so that I can get the image in the image box of the user form.

I have tried with below program

Overview

I am trying to tabulate time over days under Google Sheets and see each person's availability based on their start and end times which changes almost every week.

File Information I have this Sample Availability Timesheet with two Sheet-Tabs.

Master Sheet-Tab: This Sheet-Tab contains the list of employees with their respective start-time & end-time.

Availability Sheet-Tab: This Sheet-Tab contains the list of employees and a timescale with one hour hop. The resource availability is marked with Y, and by N if the resource is not available using the following formula: