Forum Discussion

Misha_Zainab100's avatar
Misha_Zainab100
Copper Contributor
Jan 19, 2022

Checkbox to move with sort

Hi I am looking to use a checkbox as a entity in cell and not an object so that when I filter my columns my checkbox option also move for example in below only B2 and D4 is ticked and when I want to change the order of my table from largest to smallest the checkbox doesn't move with it

 

 

Largest to smallest number, checkbox is shifted down and now I have lost my pattern.

 

 

Can anyone help with this please?

 

 

    • Misha_Zainab100's avatar
      Misha_Zainab100
      Copper Contributor
      Is there a quick way of fixing this or do I have to do one by one I have almost 600 entries in my file where I used form control and I need to convert it to Xcontrol

    • Misha_Zainab100's avatar
      Misha_Zainab100
      Copper Contributor
      Hi Thank you so much I think I have solved it by using active Xcontrols you have been a great help 🙂
      • KSoree's avatar
        KSoree
        Copper Contributor

        Misha_Zainab100 Apologies for butting in on this thread. But I was wondering what settings you changed in Active X to get your desired outcome? I'm struggling with the same challenge as you did.

         

        Thanks

        Kamil

    • Misha_Zainab100's avatar
      Misha_Zainab100
      Copper Contributor
      Thank you NikolinoDE, I want the checkbox to move with the cell but keep the order and I noticed my option for move and size with cell is disabled (greyed out) ;(

Resources