Hi -
I am trying to bring in Role. I added them as a line item in my module:
Here are all the modules:
And here are my lists:
There is a dropdown for me to manually put in the roles, but I just don't know what to do for the formula.
Can anyone please help me with how to write a formula to bring in Role?
Hi @M.Kierepka
So there is a list called 'Roles':
And they need to be assigned to people via this module (here is the grid view):
You can see in regular view that choices are already there as a drop down but I need them automatically populated:
Any ideas on a formula to do this?
Hi,
From your question, it is understandable that roles are to be assigned to users. To determine the formula, please first describe the logic on how a role should be decided for a particular user. If you're trying to bring in native 'User Roles' to a line item , that won't be possible.
Anyone would be better aligned to help you once you describe the exact logic you require
Regards,Aakash Sachdeva
@tspoon
As far as I know you need to Import the data into the module. Roles must also be available in the source file, all you have to do is to map the Roles from Source to the Roles from Anaplan. You have already imported Name, Country and other fields, similarly Roles also need to be imported.
Not sure how and why was this missed in the import action that you might have run earlier. It should have been auto mapped. Anyway just go to the "Action" and hit "Edit" option and map this line as well and run the import again
Hope that helps
Misbah
MIZ LOGIX
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
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…
