Querying details from the Sheet Name

09/02/20
Accepted

Hi,

I have several folders corresponding to different projects in a workspace. In each folder, there is a master file containing details of the project. All the projects schedule logs are referred to as 01 Project Schedule. When I run a report to query on delayed activities from the different projects, I get the following. I would like to know how I can differentiate from the different Sheet Name. Is there any field that can provide the name of the folder where the file is located? Or retrieving the hyperlink behind the Sheet Name? Thanks.



Best Answers

Answers

  • Zahir NuckchadyZahir Nuckchady ✭✭✭✭

    Hi John,

    Thanks for your feedback. I have added a column for the Project Name in the 01 Project Schedule template. But I believe it needs to be copied throughout the column to be able to retrieve the name.



    My only concern is that some PMs do not populate this column when adding new rows in their project schedule.


    Cheers,

  • Zahir NuckchadyZahir Nuckchady ✭✭✭✭

    Hi Andrée,

    Thanks for proposing the auto fill formula. This works great :)


    Cheers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Zahir Nuckchady

    Excellent!

    You're more than welcome!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • @Zahir Nuckchady , maybe create a fallout report for your PMs to manage that presents to them the Projects that have a Null Project Name. Then you can work toward making sure everything has a name or unique identification.

Sign In or Register to comment.