Checkbox populate contact list
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
Comments
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!