Checkbox populate contact list

Mitch@Enmach
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 

Tags:
· Share on FacebookShare on Twitter

Comments

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

    Craig

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!