Forum Discussion

KariLang's avatar
KariLang
Qrew Member
11 months ago

Formula for Header field

I have a header on my form that will show my process user.  I have 8 fields for process user, but I would like the one with the lead team checkbox checked as the one that shows up in the header.  I think this is doable by a formula, but I am not sure how to write the formula.  Any assistance would be greatly appreciated. 



------------------------------
Kari Lang
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    11 months ago

    np,

    List("\n",

    IF([Lead Team 1], [Process Resource 1]),

    IF([Lead Team 2], [Process Resource 2]),

    IF([Lead Team 3], [Process Resource 3]),

    IF([Lead Team 4], [Process Resource 4]),

    IF([Lead Team 5], [Process Resource 5]))

    That will make a vertical list of all Leads



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------