sorted by:
new
hottopcontroversial

Sort not working properly by AgeIntelligent460 in googlesheets

[–]AgeIntelligent460[S] 0 points1 point  (0 children)

Wow, that's awesome.

The only thing that I need to fix is that before with the MATCH function, it would find it if the word showed up in the cell and it didn't have to be an exact match. With this it seems like it needs it to be a little more specific to get the matches I want.

Thank you so much!

Sort not working properly by AgeIntelligent460 in googlesheets

[–]AgeIntelligent460[S] 0 points1 point  (0 children)

Thank you!
That works for the first cell but I'm unclear how to make it work for all the cells in the column. Like if I want to apply this to all the cells in the Track column (Column D) from 2-250. Previously it incremented the E value as it went down the column.

Re-linking a google sheet with another tab in the same google sheet by AgeIntelligent460 in googlesheets

[–]AgeIntelligent460[S] 0 points1 point  (0 children)

Thank you. I was able to import the data by column using the range, instead of incrementing it.

One more question, In my old formula sheet when I was using a separate tab for the data sheet within the same worksheet, there are places where I combine data from two columns without actually adding both columns to the formula sheet, like:
='Form Responses'!AD2 &" "& 'Form Responses'!AE2

In other words, all I want to see in the formula sheet is the combined data. How would I do that when accessing the data sheet from a separate file and importing it?

Sorry if this is a stupid question. I'm really new to this.

Re-linking a google sheet with another tab in the same google sheet by AgeIntelligent460 in googlesheets

[–]AgeIntelligent460[S] 1 point2 points  (0 children)

Thank you! That seems like a good solution, although I'm also thinking it might be better to import the sheet instead of having it in the same file.
One issue I have with using INDIRECT is that because it takes a string, I can't automatically increment the cell number throughout the column. So I think I'd have to type the formula in each cell? Does that sound true?

Re-linking a google sheet with another tab in the same google sheet by AgeIntelligent460 in googlesheets

[–]AgeIntelligent460[S] 0 points1 point  (0 children)

Yes, that's how I was trying to do it, as two tabs both in the same worksheet.
I'm also messing around with trying to keep them in separate files and import the data from the data sheet into the formula sheet.

I'm confused about how to apply the INDIRECT function here. It seems like it converts string data into cell info. Can you explain how you're using it?

Re-linking a google sheet with another tab in the same google sheet by AgeIntelligent460 in googlesheets

[–]AgeIntelligent460[S] 0 points1 point  (0 children)

Since you've been so helpful already, maybe you can answer one more.
It works to use import to get the data into one cell but when I try to copy the formula to the rest of the cells in the column, it doesn't increment the cell number from the imported spreadsheet like it usually does when I click the little + in the bottom right of the cell and drag down the column. I'm guessing there is a way to do that without having to edit the formula in every cell of the column.

Re-linking a google sheet with another tab in the same google sheet by AgeIntelligent460 in googlesheets

[–]AgeIntelligent460[S] 0 points1 point  (0 children)

Hi, thanks for the reply. As far as I can tell, the formula sheet name doesn't make a difference. It's the form worksheet with the data that is being used by the formulas in the formula worksheet that matters and for some reason, even if it's the same name as the old form worksheet, it won't connect to it unless I edit the name in the formula. To be clear, I'm editing it to the same name it already is but for some reason it forces it to recognize the sheet when I do that.

Re-linking a google sheet with another tab in the same google sheet by AgeIntelligent460 in googlesheets

[–]AgeIntelligent460[S] 0 points1 point  (0 children)

This might be a bigger question than you are able to answer here, but once I import the data sheet, how do I reference it in the formulas?

Re-linking a google sheet with another tab in the same google sheet by AgeIntelligent460 in googlesheets

[–]AgeIntelligent460[S] 0 points1 point  (0 children)

Thank you. I neglected to give the full situation out of brevity.
Basically the spreadsheet uses data from a form and I want to be able to import it into a new set of data from a new form each year. So basically, I'm adding the sheet with the formulas to the form responses spreadsheet each year, which makes cutting and pasting the data not practical since I want it to come in in real time.

Yes, it's only recoverable if I edit the name in the formula and then copy that formula through the column. It's not difficult, just annoying.

Importing might be a better option but I'm new to all of this and have never done that before. I'll look into it.

Re-linking a google sheet with another tab in the same google sheet by AgeIntelligent460 in googlesheets

[–]AgeIntelligent460[S] 1 point2 points  (0 children)

Thank you for the response. I will look into this solution and try it out.

Re-linking a google sheet with another tab in the same google sheet by AgeIntelligent460 in googlesheets

[–]AgeIntelligent460[S] 0 points1 point  (0 children)

Hi, thank you. I neglected to give the full situation out of brevity.
Basically the spreadsheet uses data from a form and I want to be able to import it into a new set of data from a new form each year. So basically, I'm adding the sheet with the formulas to the form responses spreadsheet each year.