+4I 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.
Best answer by Aleximo
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.
+8hey @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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.