Solved

UserProfileLookup - How to identify "Vice Presidents"

  • 2 March 2022
  • 1 reply
  • 15 views

Badge +4

I have a Calculated Value field in my form that displays the current users Job Title using this formula: userProfileLookup(Current User, "Title")

 

Is it possible to identify from that Calculated Value field everyone that has the word "Vice President" in their job titles?  Ideally, I'd like to have another Calculated Field that gets populated with "Vice President" anytime someone has that in their job title.

icon

Best answer by Aleximo 4 March 2022, 11:01

View original

1 reply

Badge +8

hey @jambou ,


 


u could create a new formularvariable and set it to the formula u already use in the calculated value:


 



 


after that create a new calculated value field with following formula:


 


IF(CONTAINS(varVicePresident, "Vice President"), "Vice President", "")


 



it will check if ur variable "varVicePresident" contains the value "Vice President" and if so it will set the value to "Vice President" if not the value will be empty.

Reply