I am looking for a way to automate the Batch Index column with a formula. Any help or advice would be greatly appreciated! Thank you!
@dangelo
Try using the Rank formula where the 5th parameter is the item of the Incentive Fees/Unrealized Investment Gain list.
Hi Rob, Thank you for the feedback. This was the result I got. Any feedback for how I can make this right? Thanks @rob_marshall
I thought that is what you wanted. What exactly are you needing the final result to be?
Hi Rob, My apologies. I had the incorrect pivot. That formula was just what I needed. Thank you! @rob_marshall
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…