Used in formula on: <unknown sheet>

Peggy Parchert
Peggy Parchert ✭✭✭✭✭✭

Is there a way to see who the owner of the <unknown sheet> is? I'm have multiple sheets with data that is used for various metrics. I am currently looking at revamping those sheets but I have several columns that show:

Used in formula on: <unknown sheet>

I'd like to see who the owner of the unknown sheet is to notify them of the upcoming changes. Is there someplace I can look to find this?

Any help would be appreciated.

Thanks -Peggy

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Peggy Parchert

    <unknown sheet> refers to a sheet that you are not shared on, so you won't be able to see the sheet name. Since you are not shared to the sheet, you won't be able to see who the Owner is either.

    However, in order to create the formula looking at your sheet, the person who created the formula would need to be shared to this sheet as well. I would suggest reaching out to all the users shared to this current sheet to notify them of your changes, and perhaps request that they share this unknown sheet to you as well.

    Cheers,

    Genevieve

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Peggy Parchert

    <unknown sheet> refers to a sheet that you are not shared on, so you won't be able to see the sheet name. Since you are not shared to the sheet, you won't be able to see who the Owner is either.

    However, in order to create the formula looking at your sheet, the person who created the formula would need to be shared to this sheet as well. I would suggest reaching out to all the users shared to this current sheet to notify them of your changes, and perhaps request that they share this unknown sheet to you as well.

    Cheers,

    Genevieve

  • Peggy Parchert
    Peggy Parchert ✭✭✭✭✭✭

    Thank you @Genevieve P.