Skip to main content
Solved

Pigment sheet view XLOOKUP from another sheet

  • February 10, 2023
  • 3 replies
  • 447 views
K
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 

abhilashsawla

3 replies

Chris
Wallflower
Forum|alt.badge.img+14
  • ChrisWallflower
  • Wallflower
  • Answer
  • February 14, 2023

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
abhilashsawla
K
M
Wallflower
Forum|alt.badge.img+5
  • mmusabWallflower
  • Wallflower
  • August 31, 2023

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

Benji
Chris
Wallflower
Forum|alt.badge.img+14
  • ChrisWallflower
  • Wallflower
  • August 31, 2023

@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
M

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement