I have a List-User formula field that I need to base off the new multi-select text field, how do I create a nested IF statement?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

The field used to be based off a bunch of check boxes but, I'm not sure how the multi-select field works now.

Check boxes used to be:


ToUserList(

If([Designer]=true, [Campaign / Project - Designer 1]),

If([Designer 2]=true, [Campaign / Project - Designer 2]),

If([Designer 3]=true, [Campaign / Project - Designer 3]))

but now the multi-select text 


ToUserList( 

If (([Assign a Team Member], (Designer)=true), [Campaign / Project - Designer 1], 

If (([Assign a Team Member], (Designer 2)=true), [Campaign / Project - Designer 2], 

If (([Assign a Team Member], (Designer 3)=true), [Campaign / Project - Designer 3]))

What am I doing wrong?

Photo of Kerry-Ann

Kerry-Ann

  • 40 Points

Posted 4 years ago

  • 0
  • 1
I assume that [Assign a Team Member] is the new Multi select field type and the three drop down choices are


Designer

Designer 2

Designer 3



See if this works


ToUserList( 


If(Contains(ToText([Assign a Team Member]), "Designer"), [Campaign / Project - Designer 1]), 

If(Contains(ToText([Assign a Team Member]), "Designer 2"), [Campaign / Project - Designer 2]), 

If(Contains(ToText([Assign a Team Member]), "Designer 3"), [Campaign / Project - Designer 3]))
Photo of Kerry-Ann

Kerry-Ann

  • 40 Points
Works perfectly!! Thank you.
Great. not bad for a formulal on the fly with no testing
Photo of Kerry-Ann

Kerry-Ann

  • 40 Points
Next question. I thought this would be a simple switch, but it now seams as though all my reports need to be updated because the formula in the field changed. I would have thought it would have stayed the same since the content in the field is staying the same. I've probably gone the super long way of putting this report together, but I can't think of any other way. Let me know if there is an easier way.

I want the current user to only see the records that shows up in the List-User Formula to see all the task they are assigned to.

For all personal reports I have had to do the following:

all
    any
           all
                Assign Includes the User(s) in the field [Campaign / Project - Designer 1]
             and  
               [Campaign / Project - Designer 1] includes the user(s) <the current user>

           all
                Assign Includes the User(s) in the field [Campaign / Project - Designer 2]
             and  
               [Campaign / Project - Designer 2] includes the user(s) <the current user>

           all
                Assign Includes the User(s) in the field [Campaign / Project - Designer 3]
             and  
               [Campaign / Project - Designer 3] includes the users <the current user>


I have about 12 instances of the I have to go through for each personalized report each time. I need help to get my reports to work for this new change you suggested above.

Thanks ahead of time.
I suggest that you make a new formula checkbox field ONCE to do your formula - call it perhaps

[Current User is a Designer on this Project].

Then use that as a single filter on your 12 reports.
Oh, btw, to refer to the current user in a formula you use the function
User()

If it makes more sense to you, you can make a Formula-User field called [Current User] and then use the function User() as its formula and then use that in other formuals.