Forum Discussion
Automatically fill in table based on drop down menu per row
Hey,
I'm trying to improve my teams' working schedule. In the drop down menus, people can choose their names to register themselves.
We usually work 4h shifts, so in the next table I would like to automatically fill in 4 when someone fills in their name. Column A has all the names of our team members.
I tried it with =IF(B:B=A41;4;0) but that doesn't work. It works when I do =IFS(B9=A41;4;0;B12=A41;4;0, etc), but that is a lot of work.
Is there a way to do this easily?
Thanks in advance!
9 Replies
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
HansVogelaar https://docs.google.com/spreadsheets/d/1fnJE_2StVbs7y0lWE6k-98iT6Nwnaqes/edit#gid=920090246
I get "Access Denied". You'll have to get a link that allows viewing/downloading the workbook.
https://docs.google.com/spreadsheets/d/1fnJE_2StVbs7y0lWE6k-98iT6Nwnaqes/edit?usp=sharing&ouid=101819534253894755881&rtpof=true&sd=true
Hopefully this works. Thank you for taking the time to look into it!
