Automatically fill in table based on drop down menu per row

Occasional Contributor

Hey,

 

I'm trying to improve my teams' working schedule. In the drop down menus, people can choose their names to register themselves. 

1995maaike_0-1659005844606.png

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.

1995maaike_1-1659005995267.png

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

@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.

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!

@1995maaike 

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

I changed the settings, does it work now?

@1995maaike 

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

Thank you for taking the time to look into it!

@1995maaike

See the attached version.

Thank you so much! That's great!