Skip to main content
Question

Formula Help

  • November 6, 2023
  • 0 replies
  • 47 views
Forum|alt.badge.img+8

Hello, 

I've created a formula to make another field unique based on selections in another status field. I'm not sure how to end the formula or if I have the set up correct? The error I'm receiving says "expecting comma"?

If([Referral Status] <> "Evaluation completed" , [Member ID],
If([Referral Status] <> "Evaluation not completed" , [Member ID],
If([Referral Status] <> "Member/legal guardian declined evaluation" , [Member ID],
If([Referral Status] <> "Other reason why not completed" , [Member ID])

Thanks, 
LB



------------------------------
LB
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Quickbase Alumni
    • November 6, 2023

    Looks like you're not closing out the ifs correctly. I will note that Quickbase is not like Excel so you don't need to repeat the Ifs for each condition. Try the below: 

    If(

         [Referral Status] <> "Evaluation completed" , [Member ID],
         [Referral Status] <> "Evaluation not completed" , [Member ID],
         [Referral Status] <> "Member/legal guardian declined evaluation" , [Member ID],
         [Referral Status] <> "Other reason why not completed" , [Member ID],

    "")



    ------------------------------
    Chayce Duncan
    ------------------------------
    Terms & ConditionsAccessibility statement