Automation on WHO made the status change

Jett

Hi,

We have a sheet that has over 1000 rows. There is a column "Status" that has many options to choose from. Is it possible to have an automation that will go out once a day to me with all the status changes and WHO made the changes. I know we can go into the cell history but that will be a lot with all the changes happening and many rows.

Daniel Miller PMP

You can do one of three things:

1 - Use the Highlight Changes feature in sheet bar and review that daily but be sure to have the Columns for Modified By & Modified Date setup so you can see what changes occurred, by who, and when

or

2 - You can create a workflow, but this would be row level notifications

or

3 - You can create a report only showing changes in a specific time frame and automate that to be sent to you on a specific frequency. For this to work you would need the Modify By & Modify Date columns setup as well.