Formula User based on another field

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • In Progress
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
Photo of Michael Halbreiner

Michael Halbreiner

  • 230 Points 100 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
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.