I just learned how to use the
=query function in Google Sheets, pulling information from one sheet to the next when a specific condition is met.
=query('Sheet1'!A:Z, "select B, D, E, F, G, I, L where A = 'WON'",0)
A AUG WON B SEPT PENDING C SEPT LOST D OCT WON
A AUG D OCT
In the second sheet, I add information in the columns after the ones
=query pulled in, for example:
A AUG DANNY D OCT NICKY
But when I change the source sheet, from PENDING to WON, it becomes this:
A AUG DANNY B SEPT NICKY D OCT
How do I fix it so whatever information I put in the same row adjusts with the cells it was originally put with, leaving empty cells I can fill out beside the new entries?