Checkbox populate contact list

Mitch@Enmach ✭✭
edited 12/09/19 in Formulas and Functions

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
    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!