1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • Filename appear in cell (no scripts)

    From Bob Richardson@21:1/5 to All on Wed Mar 2 06:07:19 2022
    I need the filename of my google sheet to appear in a cell because the phone app doesn't show the filename which is causing confusion for our users. I know I can use scripts but the problem is the people using the spreadsheet "make a copy" of the sheet
    for their own use but then the script won't work without them giving it permission to run (which is a hassle because they are not tech savvy and there are a lot of them).

    I need a formula to show the filename instead of a script.

    Thank you for your help!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Philip Herlihy@21:1/5 to All on Wed Mar 2 18:21:11 2022
    In article <[email protected]>, [email protected] says...

    In article <[email protected]>, [email protected] says...

    I need the filename of my google sheet to appear in a cell because the phone app doesn't show the filename which is causing confusion for our users. I know I can use scripts but the problem is the people using the spreadsheet "make a copy" of the
    sheet for their own use but then the script won't work without them giving it permission to run (which is a hassle because they are not tech savvy and there are a
    lot
    of them).

    I need a formula to show the filename instead of a script.

    Thank you for your help!

    Didn't take long to find that!

    https://support.microsoft.com/en-us/office/insert-the-current-excel-file-name-
    path-or-worksheet-in-a-cell-186833c6-c899-4912-a14c-240c2eb51e0b

    Actually - it works in Excel (which is what this group is about) but not in Google sheets! So my smug comment was a bit premature...

    --

    Phil, London

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Philip Herlihy@21:1/5 to All on Wed Mar 2 18:15:58 2022
    In article <[email protected]>, [email protected] says...

    I need the filename of my google sheet to appear in a cell because the phone app doesn't show the filename which is causing confusion for our users. I know I can use scripts but the problem is the people using the spreadsheet "make a copy" of the
    sheet for their own use but then the script won't work without them giving it permission to run (which is a hassle because they are not tech savvy and there are a lot
    of them).

    I need a formula to show the filename instead of a script.

    Thank you for your help!

    Didn't take long to find that!

    https://support.microsoft.com/en-us/office/insert-the-current-excel-file-name- path-or-worksheet-in-a-cell-186833c6-c899-4912-a14c-240c2eb51e0b

    --

    Phil, London

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)