CODEWITHSUNDEEP
google-sheetsformula
Rob Sands
Rob Sands

Reputation: 21

how do i take data from one sheet (if a cell is filled) to a separate sheet

Here is what I am using

=IF('Active Submittals'!G2<>"",('Active Submittals'!A2),"")

Where I am struggling is I want the Active Submittals sheet if G2 is filled/not blank to populate the data from ActiveSubmittals A2 to newsheet cell A3, then fill the next cell (A4) and so on, but only if Activesubmittals G is filled

Upvotes: 0

Views: 29

Answers (1)

player0
player0

Reputation: 1

try:

=INDEX(IF('Active Submittals'!G2:G<>"", 'Active Submittals'!A2:A, ))

or:

=INDEX(IF(G2:G<>"", 'Active Submittals'!A2:A, ))

update:

=FILTER('Active Submittals'!A2:A, 'Active Submittals'!G2:G<>"")

Upvotes: 1

Related Questions