spreadsheet | The Ruby Spreadsheet by ywesee GmbH | Data Visualization 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

I have a list (dput() below) that has 4 datasets.I also have a variable called 'u' with 4 characters. I have made a video here which explains what I want and a spreadsheet is here.

The spreadsheet is not exactly how my data looks like but i am using it just as an example. My original list has 4 datasets but the spreadsheet has 3 datasets.

Essentially i have some characters(A,B,C,D) and i want to find the proportions of times each character occurs in each column of 3 groups of datasets.(Check video, its hard to explain by typing it out)

I have to paste the value of variable $val in cell 'B3' in Sheet 0. After this, I have to export sheet1 as pdf.

But I can see that when I am converting sheet1 as pdf, the formulas are not printed 'as values' but they are printed as a string.

Moreover, 0's are getting populated in empty cells. Attaching screenshot of the same.

i am trying to the list all the files recursively from a google drive folder to a spreadsheet and sort the file listing by size ( Largest sized file should be on top ) . i am facing issues with the script

start function is giving the error - ReferenceError: *****folder_id is not defined (Line 16)

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:

What I want the Macro to accomplish:

I want the user to be able to fill in data from E2 to E9 on the spreadsheet. When the user presses the "Add Car" button the macro is supposed to be executed. The makro then should take the handwritten data, copy everything from E2:E9 and put it into a table that starts at with C13 and spans over 7 columns, always putting the new set of data in the next free row. It is also supposed to check for duplicates and give an alert while not overwriting the original set of data

So my problem is, that I want the Macro I'm writing to take the information put into certain cells and then copy them into a table underneath.

I'm starting the Macro like this

I have a list with dates, names and a value. I am now looking for hours for a solution to list all individual names on a specific date and count them

so the list looks like:

I'm trying to sort my rows according to the Status (B), according to a custom order. I used to have Status in A, and the code worked fine, but then wanted to add an additional column before it and everything's been scuppered. Now getting a 1004 error.

My table spans A:L. Here's the code:

So I managed to combine Google form, google calendar, as well as google sheets. When people submit the form (with a start date and end date), it will automatically appear in the google sheets as well as google calendar.

I modified the script to find conflict (to prevent double-booking), however, I just realized that even when the same person is trying to edit starting and ending date (via edit response), it will still show CONFLICT.

For example, someone books from date April 15th to April 17th, and he decided to change to April 16th to April 18th, because he previously booked 15-17, his new submission is having conflict with his own previous submission.

How can I add a function that will detect the same email to edit and submit data? (within empty day slot. Thanks in advance!

This is the function to create an object from sheet data