Is there any easy way to replace a Line Item in the whole model in all formulas? right now i have to check hundreds of modules to switch out a Line Item, which is quite tedious
//GP
Hi @GP , 1 of the ways is to copy the entire line items tab to an excel, find & replace your line item and then paste it back. It might need some work in the excel to add the ' before and after the formula but would also save you considerable amount of time. If your line item is generic & present in multiple modules with the same name then you could just rename it for this task to something very unique (both source & target line items) and then after the exercise rename it back to what it was. Hope this helps! :)
yes multiple modules, hundreds..and no, the line item is referred in other formulas in other module line items, its not just doubled by name and content. At least i could use the internal replace function (Ctrl+H) in the formula editor in anaplan, this helped its not just renaming. i want to use another (a new one) Line Item which replaces the old one, and the old should remain im already done - did it manually, but im sure i need to do this again somewhen
@GP - Yes, you could copy this tab to an excel and lets say in this example I want to change the line item "Mapping" to "Mapping new" in the entire model wherever it exists. Copy paste this tab into an excel, do a find & replace for mapping to mapping new & copy back the result.
This way all the formulas referring to mapping earlier now refer to mapping new.
i didn't dare to paste the full line item collumn 😅
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
