Forum Discussion
Summary sheet, copy entire row if a cell criteria is met
https://arengio-my.sharepoint.com/:x:/g/personal/melanie_stokes_areng_io/IQC2OhPfZnKEQL6qfPj11gqfAQSh8Em3Zp95fkYbLBTZc3g?e=oNU1pEHi Can you please help me, I have a schedule for jobcards, each tab i...
I have entered this formula onto that sheet:
=LET(in,TRIMRANGE(VSTACK(start:end!A1:Z1000)),out,FILTER(in, CHOOSECOLS(in,20)="Incomplete"),IF(out="","",out))NOTES:
- I inserted 2 sheets: 'start' and 'end' to mark the range of sheets to check
- this formula does NOT filter sheets that have been named ... -CLOSED
- your header on the 'OUTSTANDING JOBCARDS' sheet only goes to column O (DAYS OUTSTANDING) but this formula pulls the full rows through column U. If you only want through column O then you can wrap the final part of the LET statement with a TAKE so the end would look like: TAKE(IF(out="","",out),,15) )