Skip to main content
Solved

Pigment sheet view XLOOKUP from another sheet

  • Feb 10, 2023 11:08 AM UTC
  • 3 replies
  • 793 views
Wallflower
Forum|alt.badge.img+2

Dear community, 
I hope you are all well.

Concerning the new pigment update of sheet view.

How is it possible to do an XLOOKUP from another sheet?

 

Thank you

Best answer by Chris

Hi @Khadija,

 

When working with formulas in Sheet view, you can only reference data from that Metric (Sheet).  Any references to other Metrics must be done with Pigment formulas. 

 

Thanks

Chris 

View original

    3 replies

    Chris
    Wallflower
    Forum|alt.badge.img+14
    • ChrisWallflower
    • Wallflower
    • Answer
    • Feb 14, 2023 12:56 PM UTC

    Hi @Khadija,

     

    When working with formulas in Sheet view, you can only reference data from that Metric (Sheet).  Any references to other Metrics must be done with Pigment formulas. 

     

    Thanks

    Chris 

    Chris
      Wallflower
      Forum|alt.badge.img+5
      • mmusabWallflower
      • Wallflower
      • Aug 31, 2023 5:22 AM UTC

      @Chris , is this something on the roadmap cause it will be a really good feature.

        Chris
        Wallflower
        Forum|alt.badge.img+14
        • ChrisWallflower
        • Wallflower
        • Aug 31, 2023 2:14 PM UTC

        @mmusab   Currently this is not something on the roadmap. 

        We do have a Google sheet and Excel connector available if you wanted to perform these types of connections. 

        You can also request it in our ideas section so others can upvote to show interest.  

        Chris

          Ask your question here!

          Terms & ConditionsAccessibility statement