Discussions

Expand all | Collapse all

Formula User based on another field

  • 1.  Formula User based on another field

    Posted 12-14-2018 19:57
    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


  • 2.  RE: Formula User based on another field

    Posted 12-14-2018 22:13
    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.