Track Changes of a Column in another Column

1

So I have a list of people that get assigned a random group every week. Is there a simple way to keep track of the history of which groups they were assigned each week? So what I’m looking for would look something like this:

Week One:
image

Week Two:
image

Week Three:
image

Thanks for your help!

2

Hi Samuel,

I do something a little bit more elaborate to keep a record of weekly updates.

image

Pushing the button will copy the previous comment to an archive column, and it currently add todays date to the update column.

This is the code for the button:
If you do not need the date, you can remove the lines in italics.

ModifyRows(
thisRow,
[Action Item List].[Action Update archive],
Concatenate(
thisRow.[Action update], Character(10), thisRow.[Action Update archive]
),
[Action Item List].[Action update],
Today().DateTimeTruncate(“day”)
)

Regards
Piet

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.