Forum Discussion
filter formula frustration
Hi, I'm wondering if someone can help me. I want data from spreadsheet B (invoice tracker) to auto populate lines in spreadsheet A (invoice request). Sounds simple and the FILTER formula I've appli...
I'm really not following what the issue is here. You example formula looks fine to return the values from column N when values in column O are >0. IF you want to return column N when values in column O or P or Q are >0 then you can use
=FILTER('Invoice Tracker'!N3:N58,('Invoice Tracker'!O3:O58+'Invoice Tracker'!P3:P58 + 'Invoice Tracker'!Q3:Q58)>0)
but that assumes all those values are 0 or positive number or at least their isn't a chance that the sum isn't <=0 but if that is possible then you could "or" the individual comparisons:
=FILTER('Invoice Tracker'!N3:N58,('Invoice Tracker'!O3:O58>0+('Invoice Tracker'!P3:P58>0) + ('Invoice Tracker'!Q3:Q58>0))
but then again I may be way off on what your issue is.
Could you please attach or give a link to sample example sheet?
=FILTER('Invoice Tracker'!N3:N58,('Invoice Tracker'!O3:O58+'Invoice Tracker'!P3:P58 + 'Invoice Tracker'!Q3:Q58)>0)
but that assumes all those values are 0 or positive number or at least their isn't a chance that the sum isn't <=0 but if that is possible then you could "or" the individual comparisons:
=FILTER('Invoice Tracker'!N3:N58,('Invoice Tracker'!O3:O58>0+('Invoice Tracker'!P3:P58>0) + ('Invoice Tracker'!Q3:Q58>0))
but then again I may be way off on what your issue is.
Could you please attach or give a link to sample example sheet?
mtarler thanks for your reply. I seem to have solved the problem 🙂
