Hi Everyone
Looking for some advice, I'm currently making a checklist that tracks a project that my team is assigned, and I'm wanting to make it all as hands-off as possible.
I've managed to get far enough to have items cunt due dates or go red when late etc, however, the final stages are a little complicated.
I'm stuck trying to get the following things to works:
Row A in Book1 has a list of languages that may be needed, with the lead putting a Y or N in the B row if needed.
In order to track this progress, I want to build a table in Sheet 2, where Row A contains only the items marked as "Y" and does not have any blank spaces.
I've used "=IF(Sheet1!B3:B23="Y",Sheet1!A3:A23,"")" but this leaves blanks in the table is there a more clean way to do this, that's beginnerish(friendly).
Additionally, for items on sheet two based that arent languages, if these are N certain items in the checklist won't be needed, I've greyed these out with conditional formatting, but is there any way to either
A: Hide the row and have them not but part of any counts
B: Build on the following formula in the complete tab "=IF(ISBLANK($D28)=FALSE, "Y", "N")" to add N/A to in the case any items are marked as N on Sheet2



