Excel Sheet With Reminder Free To Read

First, we want to check if the current date is equal to or less than ( TODAY() function to get the current date.

I use something like this in my day to day to keep track of a number of reporting processes.

Excel Sheet With Reminder Free To Read

Feel free to read what you need or skip to the end for a link to the google sheet for you to make a copy of.

Admin can easily copy the emails and send a message to those staff who have not completed their report by the deadline.

The problem here is that if a staff member changes position or needs a correction to their details, then you have to go into every sheet that the user is on and change it.

A much better approach is to import the users details from a core Google Sheet of user data that you use for all your spreadsheets.

That way you are only changing one spreadsheet and the changes will apply to all.

Dont worry about making it pretty yet, we will tidy it up later.

You will need to make this file your own to use in your sheet.

To do this. click File Make a copy.

You can put that file anywhere but for now, put it in the same folder as your Quarterly Report Checklist Google Sheet.

This function allows you to get data from another sheet and put it in your current Google Sheet.

You will need to combine this with the range of names and emails.

Note the after Staff and make sure you put it all in double quotes.

If so, click allow.

If everything was successful, your sheet should now look like this.

Then go to columns E, F and G and click and drag the right edges in so that they are a little narrower.

This will help users identify that this is for admin use and not for them.

Resize to 14 and then got to File Align Centre, then File Align Middle.

Click the first line below row 1 on the far left and drag it down to give it a bit of space.

You can change yours to Month, Day and Year if that is what you are used to.

Just go to Format Number More Formats More Dates and Times Formats.

Then got to the adjacent border icon and click it select the border colour to a dark grey then select the full border.

If it is past the due date and Report Complete had not been checked, then we want the cell to display Overdue.