Formula input position

Formula input position

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

• 

  nvitqrlfeqbusuabfa

  • Post Options:
  • Link
    Copy

  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.

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 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