We have a workflow where we have two boards - Board A and Board B and one of the column types is “People” and people who are in that Board A are assigned in that column.
We then have an automation setup that when a status changes, at item is moved to Board B - and the people in Board A do not have Access to Board B. However, we would like to keep a record of the people who did work on the item in Board A.
Currently, if a person - let’s say “John Smith” it assigned to an item in Board A (that he has access to), when the item is moved to Board B (that John doesn’t have access to), his name is removed from the item.
I get why this is happening - but I am wondering if there is any way that we can keep a record of John’s work in a column. Ideally, there would be some kind of automation that would allow me to “Change column Type” to change it “Text” type with the same information - then John Smith would be in the column as text instead of as a person - but that doesn’t seem to be possible.
Does anyone have ideas of a different workflow that might allow us to do what we are trying to do?