Using Custom Names globally

Using Custom Names globally

Posted by: tadekunle on 18 May 2021, 9:25 am EST

• 

  tadekunle

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 18 May 2021, 9:25 am EST

  Hello,

  I am trying to use the custom names I created in a sheet in formulas contained in a different sheet. So if I have 2 sheets, Sheet1 (which has a custom name = customName1) and Sheet2, I would like to use the custom name from Sheet1 in Sheet2 by just typing “=customName1” into a cell in Sheet2. I tried creating the custom names at the workbook level but it does not give me the correct value.

  Thank you,
  
  Tolu

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 18 May 2021, 11:08 pm EST

  Hi Tolu,

  We are sorry but unable to replicate this issue at our end, custom name on workbook giving us the right on each sheet. Please refer to the following sample that demonstrates the same and if the issue persists please modify the sample to replicate the issue so that we could investigate it further and assist you accordingly

  sample: https://codesandbox.io/s/musing-clarke-y5gl0?file=/src/index.js

  Regards,
  
  Avinash

• 

  tadekunle

  • Post Options:
  • Link
    Copy

  Posted 31 May 2021, 9:40 am EST

  Hi Avinash,

  The issue has been resolved, thanks!