I have data and I want to combine it with IMPORTRANGE. For each IMPORTRANGE, I would like to add a column with specific data afterwards.

I’m trying to figure out a way to replace all these indirect into this formula:

I’m trying to figure out a way to replace all these indirect into this formula:

I’m trying to figure out a way to replace all these indirect into this formula:

In Google Sheets, I am using the formula shown below to count dates meeting this criterion: >=7/1/2023

Each individual word must exactly match (not case sensitive) the value of the line of text.

When I’m trying to load data from https://2e.aonprd.com/Backgrounds.aspx, the table doesn’t seem to initially load, resulting in what seems to be an empty data set. Is there a way to use importxml to load the entire data set?

My use case is more complex than this but I think this example illustrates my problem clearly.

Google Sheets defines several unary functions and operators, and while most of them seem to have a purpose, UPLUS‘s help article says

Google Sheets defines several unary functions and operators, and while most of them seem to have a purpose, UPLUS‘s help article says