'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
Solution 1:[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<>"")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |