Forum Discussion

KariLang's avatar
Qrew Member
6 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

1 Reply

  • np,


    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)