Forum Discussion
Solved
Pulling data using drop downs
Hello, This may not be possible, but can you input 'Consultant' and 'Month' in the below and it will auto generate the active, completed and closed columns. and it will then be able to pull t...
Like this?
Thank you.
Pretty new to all this, i think i've made a link and it will be shareable, there is no important data in there.
https://docs.google.com/spreadsheets/d/1x_LYOXuB6k9VOSa-ZZGDK_q1jWlxPsAW/edit?usp=drivesdk&ouid=117707044031102458887&rtpof=true&sd=true
Thanks again
Pretty new to all this, i think i've made a link and it will be shareable, there is no important data in there.
https://docs.google.com/spreadsheets/d/1x_LYOXuB6k9VOSa-ZZGDK_q1jWlxPsAW/edit?usp=drivesdk&ouid=117707044031102458887&rtpof=true&sd=true
Thanks again
Does this do what you want?
Thank you so much for this Hans.
Do you know the formula you used? As in hindsight it may be easier if I just had all the names already on there and just had to update the month. Like below;I tried dragging down each column thinking the formula would carry over but no luck.
Like this?
- Thanks again Hans, this is it - only issue i am having is i think it works on the 'Active' and 'Closed' and it's not capturing the 'Completed' i input 10 cases to test and all are accounted for except the 3 i set as 'Completed' is there something i am doing wrong?