Building a live issue log with excel

Copper Contributor

I am creating a issues log. on tab A I have a generated Issue ID (A Column).  In column M I have a dropdown list validation for yes/no to add screenshots. IF column M is yes than the issue Id in Column A will generate in tab B, column A (=FILTER(Table4[[Issue ID ]],Table4[Screen Shot (Y/N)]="Yes")) . The problem is I cant make the issue id and the screen shoots stay together if someone decides to change a no to a yes. I cant make tab B a table due to the formula. does anyone have any ideas on how i can get this to work.

0 Replies