Use Index Collect to Pull in Formula?
I'm creating a project plan that uses index collect to pull information from another sheet into my project plan. Everything works great but on a couple cells I'd like to pull in a formula. Is there a way to do this? In my other sheet I've inputted the formula which shows #UNPARSEABLE (because I don't have the references connected) and the index collect will pull in the #UNPARSEABLE instead of pulling in the formula. I've also tried to put quotes around the formula in the other sheet but then it just thinks it's text and shows what the formula is but doesn't allow the formula to do the work. I'm not sure if there's another way I'm missing that could work.
Answers
-
You will need to correct the formula that is throwing the original error.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!