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
View original
Pigment sheet view XLOOKUP from another sheet
Userlevel 6
+7
- Community Manager
- 292 replies
-
14 February 2023
- Answer
Hi
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
Userlevel 2
- Enthusiastic Pigmenteer
- 9 replies
-
31 August 2023
Userlevel 6
+7
- Community Manager
- 292 replies
-
31 August 2023
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.