I am trying to find the best way to have a report that leadership and project managers can look at that will show our projects in a certain status (Similar to on hold) and also have a column that can have a status/note in there from the PM so everyone knows what is going on with the project. I dont want to use a custom form as I want the historical data and this could be updated multiple times during the project live span, and the last update won't work as other things could be happening on the updates page. My thought was to create a notes report and look for that last update that contains specific words and have the PM use those to start these kind of updates. Not finalized the wording but something like "PM Status Update:" and then they would add in what the status is.
Does anyone know if this is possible or have a better suggestion to accomplish this?
Topics help categorize Community content and increase your ability to discover relevant content.