Jun 14 2022 04:45 AM
Good afternoon,
Could someone offer some advice. Basically I am trying to get the name in Column D to appear in another tab 'Filed', if the text in Column M states 'filed'. I should also say that there several different types under WF Status, not just Filed and WIP. Would anyone know a formula that would work?
Jun 14 2022 05:20 AM
Jun 14 2022 06:11 AM
@mtarler so I have tried this, but it is spilling the same name then into every row? (see image attached.)
Basically what I intend to use this for, is that I currently have an online excel spreadsheet which I use as a workflow tracker for all our clients. I then have various meetings per week, where I check the status of all work and update the spreadsheet accordingly. However, one of my colleagues has now requested that I give her a list of all work that has been completed i.e. 'filed' after every meeting, so fees could be raised. So, I was hoping to simplify this, so that every time I marked a client 'FILED' on my spreadsheet, their name would automatically appear on a separate tab/sheet, that I would then give my colleague access to
Jun 14 2022 03:50 PM