I’m currently working in Google Sheets. When I want to set a link from one “Worksheet” to another “Worksheet”, I usually do the following:

I’m trying to filter rows by if certain columns aren’t empty. I am determining those “certain columns” with a control row of true or false values. How can I do this with formula only (not custom functions) for speed and to keep the images/formulas working when the data spreads through the sheet?

I am trying to use AVERAGEIF, or a similar function, to find the average of values in a column if a name appears elsewhere in the row. Normally this is a straightforward use of AVERAGEIF, but the name could appear in a few different columns within the row.

I am trying to use AVERAGEIF, or a similar function, to find the average of values in a column if a name appears elsewhere in the row. Normally this is a straightforward use of AVERAGEIF, but the name could appear in a few different columns within the row.

I am trying to use AVERAGEIF, or a similar function, to find the average of values in a column if a name appears elsewhere in the row. Normally this is a straightforward use of AVERAGEIF, but the name could appear in a few different columns within the row.

I am trying to use AVERAGEIF, or a similar function, to find the average of values in a column if a name appears elsewhere in the row. Normally this is a straightforward use of AVERAGEIF, but the name could appear in a few different columns within the row.

I am trying to use AVERAGEIF, or a similar function, to find the average of values in a column if a name appears elsewhere in the row. Normally this is a straightforward use of AVERAGEIF, but the name could appear in a few different columns within the row.

In the image attached Portfolio, how can I search for all assets bought before the Sell date? So, if you look at the attached pic, in the last row, 3rd column. I want to search for all the XRP assets prior to the sell date of Dec,3 2024 and add a “Sold” note to a cell in the same row of the bought XRP assets. Hope that makes sense.

In the image attached Portfolio, how can I search for all assets bought before the Sell date? So, if you look at the attached pic, in the last row, 3rd column. I want to search for all the XRP assets prior to the sell date of Dec,3 2024 and add a “Sold” note to a cell in the same row of the bought XRP assets. Hope that makes sense.

For example: if the rows with row numbers: 3,4 or 5 need to be marked.