Locking Columns/Drop Down Lists

I need to be able to protect formulas in a column for the parent rows but still want people to be able be able to select child drop down cells. If I lock the column will this stop people from being able to use the drop down lists? If so what other options do I have to protect the parent rows' formulas?

Answers

  • Frank Falco
    Frank Falco ✭✭✭✭✭✭

    If you Lock the parent rows, that should protect the formulas and allow you to edit the children popups.

    This will stop Editors but not Admins from editing the parent formulas.


    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!