Forum Discussion

MichaelHalbrein's avatar
MichaelHalbrein
Qrew Cadet
7 years ago

Formula User based on another field

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
Formulas and functions
Tables and fields
  • AlexCertificati's avatar
    AlexCertificati
    Qrew Cadet
    7 years ago
    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.