Attempting to add to a large formula but getting #unparseable
Attempting to add a fifth sheet reference mimicking the previous ones in the formula however getting UNPARSEABLE. I attached a photo of the formula and the updated one below (if i paste it breaks my post) and when in the sheet i notice that the () around cell are orange on the original and green on the new ones so maybe i broke it somewhere along the
way?
Best Answer
-
You forgot an opening parenthesis after the last COLLECT and "@cell" is case sensitive (you have "@Cell" with a capital "C" when it should be lower case).
Answers
-
You forgot an opening parenthesis after the last COLLECT and "@cell" is case sensitive (you have "@Cell" with a capital "C" when it should be lower case).
-
Ok, thank you! It got rid of any error # however no data is showing and this is what happens when i try to give the entire column the formula…updaed formula below too
-
It is because you are using absolute references and specifying row numbers. You can't use the $ to lock in a column and all row references must be "@row" for a column formula.
A way around this would be to use a sheet summary field to reference the specific cell and then use a summary field reference in the formula which can be used in column formulas.
So
=[Last Year]102
would go in a sheet summary field, and then you would replace all of those references in your formula with
[Summary Field Name]#
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!