Edit Locked Column with CheckBox

Gaurav Chauhan
Gaurav Chauhan ✭✭✭✭✭✭

Hi Team

Is it possible to enable the Applicable checkbox in a way that the two locked columns KPI Goal and KPI Achieved become unlocked for the user to input details.

I have build the automation rule but its not working as required. Dont wish to create a helper column in here.

Thanks

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Gaurav Chauhan

    I hope you're well and safe!

    What's not working with the Workflow?

    • Do you have access to Dynamic View?
    • Would it work in a form?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Gaurav Chauhan
    Gaurav Chauhan ✭✭✭✭✭✭

    Hi @Andrée Starå ,

    No, we dont have access to Dynamic view.

    This feature would be for Sheet and not forms.

    Automations only lock/unlock rows so I tried that earlier. But if the row is locked, the user with edit access cannot overide that and check the box

    If I lock the Column, there is no rule on automation except for Cell Change value.

    Wondering how can a check box feature be best utilized