hello- I have two questions;

First question: Is there a way or code I can add to a spreadsheet that will auto populate to the next sequence of numbers when entering a date to the first column? I would like that sequence to automatically appear in the highlighted column in the format attached.

I am creating a spreadsheet that multiple users will be using and I am trying to avoid duplicate numbering.... below are the columns to the DRC-2017-001 are the numbers I'd like it to automatically generate under the column "Auto generated BOX #"



Date MEMBER NAME /DEPT CASE# TYPE OF CASE YEAR OF CASE PENDING / COMPLETE LONG DESCRIPTION Auto generated BOX # File Checked out by who? Checked back In
DRC-2017-002


2nd question:
I also plan on adding a condition where we enter information under the column "file checked out" the entire row would highlight to show a file has been checked out. Is that the best way to go about it?