Tracking that project has an update or not

jedelman

I have a project tracker for my entire team with very simple information as it is a very high level overview of all active projects.

My CEO will be checking the information weekly so I planned to do a Weekly Update Request that goes out to my team to 'remind' them to add any updates to their projects.

Since some of these are very long term projects, more than likely they won't have anything needing to be changed week to week but I still need to know that they took the time to consider whether to update or not. Is there a way to allow my team to communicate "No Update" to make sure they took the time to jump into the sheet to reflect that nothing had changed?

I then envision my CEO being able to select Highlight Changes for the last week to see that everyone has at least updated or not updated their projects.

Paul Newcome

I would suggest inserting a date type column and having them enter the date whether they make changes or not. You can then use conditional formatting to highlight rows or pull a report based on the date column to show those rows that have been updated most recently.

Paul Newcome

I would suggest inserting a date type column and having them enter the date whether they make changes or not. You can then use conditional formatting to highlight rows or pull a report based on the date column to show those rows that have been updated most recently.

jedelman

Thank you Paul. Simple and does the trick.

Paul Newcome

Happy to help. 👍️