Tracking that project has an update or not


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!