user Crackers707 said:
Detect a 1,2,3 and put a letter in another cell - multi complex formula
I've tried searching and searching but I don't think anyone has asked this before. Essentially I am trying to make a timesheet for multiple employees. Each employee has a Tab along the bottom. The day/date is across the top left->right and the hours down the left side. Each employee will manage their times by placing a number in the respective date/time as such:
Eseentially the cell might have ADHG to indicate 4 people are available at that particular time. I have my doubts but is this possible???
Thanks so much :)
I think now i've actually made this doc public: https://docs.google.com/
As i've written above I want it so that each employee has their own availability tab, marking in each timeslot whether they are available or not
The overview page then needs to give me an indication as to what people are available on each day/time. Probably indicated by the letter of their first name... I hope this makes sense... I don't think it's going to be possible so <don't> bother spending too much time stuffing around with it