Skip to main content
Question

List If Formula

  • October 7, 2025
  • 0 replies
  • 72 views
Forum|alt.badge.img

Why is my list if formula only returning the first if statement 

List(", ",
If([Engr check]=true and [Engr Approval Status]<>"Approved",UserToName([Engineering Manager Assigned]),
If([Production Check]=true and [Production Approval Status]<>"Approved",UserToName([Production Manager Assigned]),
If([Quality Check]=true and [Quality Approval Status]<>"Approved",UserToName([Quality Manager Assigned]),
If([Additional Check]=true and [Additonal Approval Status]<>"Approved",UserToName([Additional Approval Assigned]))))),"")

MarkShnierYou
Forum|alt.badge.img+24

Well, you don't want your IFs to be nested like that with all the closing brackets at the end.  Try this

 

List(", ",
If([Engr check]=true and [Engr Approval Status]<>"Approved",UserToName([Engineering Manager Assigned])),


If([Production Check]=true and [Production Approval Status]<>"Approved",UserToName([Production Manager Assigned])),

If([Quality Check]=true and [Quality Approval Status]<>"Approved",UserToName([Quality Manager Assigned])),


If([Additional Check]=true and [Additonal Approval Status]<>"Approved",UserToName([Additional Approval Assigned]))

Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement