help with team based spreadsheeet

[Cowboygeeker]

First time poster. I am creating an excell spreadsheet for our team members to use to track sales and display information. We ere using skype whiteboards previously but we have switched to microsoft teams and we dont have access to any apps other then excell... so far. Anyways first thing is I have set up a spread sheet so people can keep track of sales and the first line is what everyones shift time is for the day. now on a second page i have a list of the days and a place for everyones shift during the 7 days. I managed to create a drop down box that you can select the day mon, tue, wed etc. how do I get the value of each persons shift cell to change to a cell that contains that days shift?

 

[jnachrei]

It depends how detailed you want to be, however in any case its quite simple. For example in the "Date" cell you have selected, go to the formula bar and enter =TODAY() and upon opening the form it will enter the date at that moment in time. You can also have it record time (and military time as well), among much more.