New formula for checking User's access

New formula for checking User's access

As a Model Builder, I would find new function really useful:



Returns Boolean, "TRUE" if User has specified access, where:

  • x: Users list-formatted line item containing .
  • y: Item of the list with Selective Access enabled.
  • f: Flag which tells which access formula should test, keywords: "ANY" (default), "WRITE", "READ" (optional).

We need it to set DCA really dynamically, based on real SA, and not on some imports like we do now.

Community Manager
Status changed to: Your support is needed
Occasional Contributor



As a model builder I need smth familiar to the idea described below, so I decided to put this as a comment, not as a separate idea. 

I'd like to use Workspace Admin boolean in my formulas (example is on the screenshot attached).

It would be super-useful for dynamic cell access management



Certified Master Anaplanner



This formula for HASACCESS is not working, i was selecting selective access to one of my list formatted line item but that is also not working. 


Is there any solution update to the same ?

Occasional Contributor

Hi, @NakulAggarwal!


The formula HASACCESS does not exist in Anaplan, it's just an idea proposed by @M.Kierepka

The full list of exisitng formulas is here:

Master Anaplanner/Community Boss

This would make life particularly useful especially when the user based is approaching 1k!

Regular Contributor
Status changed to: Under Investigation
Users Online
Currently online: 230 members 517 guests
Please welcome our newest community members: