Checkbox populate contact list

Mitch@Enmach

Hello all,

I am hoping someone knows of a formula that could automatically populate a contact list when a checkbox is ticked. It is a sheet that keeps track of inventory and I would like to be able to keep track of who is breaking the minimum quantities without relying on the person to use a drop down box to insert their details 

J. Craig Williams

Unfortunately, no formulas of any kind are allowed in a Contact List type columns.

We can also not access the cell history from the UX other than visually.

If you have access to Activity Log, you can get a better view than via cell history, I believe.

Lastly, even if you were to build a different sort of formula (say using the [Modified By] column, this would change depending on the last person to modify the row, not a specific cell in the row.

Craig