I want to ask about numbering that repeats itself with the same conditions based on Column B and is limited to only 1 and 2 then returns to 1 so on.
as an example :

I have a problem that my shared web page from Google sheet is not automatically updating. I have the shared web page and google sheet side by side.

I am trying to combine 2 sheets for now all data columns are rows are needed and they have the same format and column headers, but in the final data I need to add a date in column A which 1st data is from 2024-07-01 and the other sheet is 2024-08-01 in date format. How can I combine them?

I am tracking information about students in a Google Sheet. Sheet 1 has each student in their own row, and the columns are different characteristics of that student (for example, their t-shirt size and their grade), as well as their attendance at each session of a class. On Sheet 2, I want to create a stand alone list of all the students from Sheet 1 who were absent for a given class session. I also want the list on Sheet 2 to update any time there’s a change in the column on Sheet 1. For example, if a student was marked here, but was actually absent.

Ive used the following formula to write out the numbers 1-4 in random order:
=ARRAY_CONSTRAIN(UNIQUE(BYCOL(SEQUENCE(1,50),LAMBDA(r, RANDBETWEEN(1,4))),1),1,4)

We’re trying to find the first date in a list that is more recent than today.

I am trying to calculate the next future invoicing date given an initial renewal date and a increment time (given in months) without using Google scripts.

function onEdit(e) { if (!e) return; var range = e.range; var sheet = range.getSheet(); var SheetName = “Civilian”; if (sheet.getName() === SheetName) { // Get the edited cell’s address var editedCell = range.getA1Notation(); if (editedCell === “J5″) { var oldValue = e.oldValue; if (oldValue === undefined) { oldValue = ”; } sheet.getRange(“K5”).setValue(oldValue); } } } […]

I have a column with of strings joined with “,” with an example being “john,dora,sally” and in two other columns I have individual names and salary with examples being “john” and 25 respectively.

I’m trying to create a dynamic list of keywords which allows to automatically search for every keyword in a specific website.