Solved

Pigment sheet view XLOOKUP from another sheet

  • 10 February 2023
  • 3 replies
  • 325 views
K
Userlevel 2
Badge +1

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

icon

Best answer by Chris 14 February 2023, 13:56

View original

3 replies

Chris
Rank
Userlevel 7
Badge +13

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
M
Rank
Userlevel 3
Badge +4

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

Chris
Rank
Userlevel 7
Badge +13

@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

Reply


Ask your question here!

Terms & ConditionsCookie settings