1 / How To Create And Rename A New Edition Of The Time Analysis Spreadsheet

1. Go to the Red Hot - Strictly Savvy SharePoint Group

2. Left click the Modified column and select Newer to older to view the latest edition of the time analysis spreadsheet

3. Down the left-hand side of the files, tick the latest edition of the time analysis spreadsheet

4. Select the three dots displayed on the line of the file you have selected 

5. Select Copy to

6. Select Current Library 

7. Select Copy here

8. Select the copied file - it will have the same name as the file you have copied, but will have a 1 on the end of it:

eg 20190715_SS Time Analysis_2019-201

9. Select the three dots displayed on the line of the file you have selected  

10. Select Rename

11. Change the date to today's date in the format of YearMonthDay and remove the 1 at the end of the file name. For EOM Invoicing the spreadsheet name will include EOM and the name of the month you are invoicing for:

eg Weekly: 20210723_SS Time Analysis_2021-221 will become 20210730_SS Time Analysis_2021-22

OR  EOM Invoicing: 20210730_SS Time Analysis_2021-221 will become 20210801EOMJUL_SS Time Analysis_2021-22

12. Select Save