Using Custom Names globally

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

  • 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
  • Replied 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
  • Marked as Answer

    Replied 31 May 2021, 9:40 am EST

    Hi Avinash,

    The issue has been resolved, thanks!
Need extra support?

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

Learn More

Forum Channels