Skip to main content
Question

Formula User based on another field

  • December 15, 2018
  • 0 replies
  • 43 views
I have a field that is multiple choice called [Data Source].  I also have a [Data Manager] formula user field.  I want the formula user field to automatically fill a particular user based on the selected [Data Source], showing the user name.  I was trying to do this with Case() but couldn't figure out how to define the user argument correctly.  

Thanks,
Scott
    This topic has been closed for replies.

    It's frequently a better forward-looking setup choice to put the user assignments into its own table instead of in a formula in another table. Easier to maintain. Also has the added benefit of obviating your need to write a formula - use a lookup instead.
    Terms & ConditionsAccessibility statement