Automatically fill in table based on drop down menu per row

[1995maaike]

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!

[#2]

@1995maaike 

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.

[#3]

https://docs.google.com/spreadsheets/d/1fnJE_2StVbs7y0lWE6k-98iT6Nwnaqes/edit?usp=sharing&ouid=10181...

Hopefully this works. Thank you for taking the time to look into it!

[#4]

@Hans Vogelaar https://docs.google.com/spreadsheets/d/1fnJE_2StVbs7y0lWE6k-98iT6Nwnaqes/edit#gid=920090246 

[#5]

@1995maaike 

I get "Access Denied". You'll have to get a link that allows viewing/downloading the workbook.

[#6]

I changed the settings, does it work now?

[#7]

@1995maaike 

Yes, I have downloaded the workbook and I'll take a look.

[#8]

Thank you for taking the time to look into it!

[#9]

@1995maaike

See the attached version.

[#10]

Thank you so much! That's great!