I have two problems. I am trying to create a Triage Note Sheet for a Doctor's office. It would be great to be able to have the Date and Time populate the sheet upon opening it, but it is important that the date and time be fixed on that sheet from there on out. Also, I'd like to give as many drop-down options as possible for users but I want to also give them the option to free text in those same drop down cells.
First, I would like to use the NOW function in a cell (C6), then lock that value when another cell (C7) has a text string entered in it. C6 would remain locked even after the worksheet was saved and edited repeatedly.
Second, I would like to use the validation feature and create a list that has multiple values to select from. I would also like to be able to free text in that cell if needed.
Any help would be appreciated.
Bookmarks