function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
nksfnksf 

Custom Setting for Text Formula Field

Hi,
I need help with text formula field. I need to display text value in formula field based on the Profile. Is there a way I can create custom setting which include multiple Profiles total 34 of them and then create formula field based on the Custom Settings? If these 34 Profiles are in Custom Settings then show Text in Formula Field as "SSO Profile". If Profile Name is not in Custom Settings then show Text in Formula Field as "Non-SSO Profile". 
If it is not possible then what would the Formula I have to enter in Formula Field so I don't reach the limit. I am trying to create one but I am exceeding the limit. I am also having issue using OR in IF Condition. 

I prefer to have Custom Settings so I can Add/Remove Profiles from there without changing the Formula. 

Thanks in advance!
RD@SFRD@SF
Hi nksf,

Try hierarchical custom settings, you should be able to create one for eacch profiles you have, but you should be able to get what you need.

Hope it helps
RD