Formula input position

Posted by: nvitqrlfeqbusuabfa on 10 May 2022, 7:29 pm EST

  • Posted 10 May 2022, 7:29 pm EST

    Hello!

    I would like to ask if it is possible to change the default behavior of cell referencing.
    I would like to allow the user to reference A1 cell in the A1 cell of the other sheet just by the clicking. This however cannot be achieved at the moment, because the cell is blocked by the input where the formula is being written.

    Is there a way how I could achieve it?

    Thank you in advance.
  • Replied 12 May 2022, 8:38 pm EST

    Hi John,

    We were able to replicate the issue at our end and hence we have forwarded this to the concerned team for further investigation. The internal id for this is: SJS-13017. We will let you know when we have an update on this issue.

    Regards

    Ankit
  • Replied 16 May 2022, 3:23 am EST

    Hi John,

    You can you any of the following workarounds as suggested by the devs to counter the issue:

    1. Select B1 in Sheet1, then use the arrow key to navigate to A1.

    2. Resize column A, then select the A1.

    Regards

    Ankit
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels