I have a Projects list with a multi-line text column named Progress Update set to "Append" to create a record of updates.
This appended Progress Update column saves a "blank" value when a list item is edited, but no user value is added to the column. This was causing reports from this list to show a lot of items as not having a Progress Update value if the last item edit didn't include a new value for the column.
To provide the last “non-blank” entry for reporting, I created a workflow placing only non-blank values from the Progress Update column into another column named Progress Update - Latest. (This blank value is actually
<div></div, fyi). The Progress Update - Latest column uses the default "replace" setting, so it always shows the last update where the user proved values.
I now need to provide for the display of all list items that have not had updates made to the Progress Update in the last two weeks. I created a column called Last Updated and added a step to my workflow placing a list-item's Modified date in the Last Updated column when it get a non-blank value added to the Progress Update - Latest column. This effectively gives a date value for the last update in list views.
The issue is that both the Progress Update - Latest and Last Updated columns will continue to be blank until a list item receives a new Progress Update value. My new columns are blank for all items not having a new value provided since applying the workflow.
There’s been consideration of asking the assignee of each project to re-enter their last Progress Update so it's duplicated to the Progress Update - Latest column, but I'm advising against doing so as it would create a new date value in the Last Updated column not reflecting the true time since an actual progress update. I need a method for capturing more accurate – and less inferred - data.
<div></div> values, but I am only just beginning to learn about the latter option, and so far have been unable to find any resources online for doing so via workflow.
Any suggestions on either of these methods? Or any other method within the confines of client-side ListView access?