Forum Discussion

SheilaAllas's avatar
SheilaAllas
Qrew Trainee
2 years ago

Formula Help Needed

I currently have 3 formula text fields to track status of 3 separate events.  I want to create 1 formula fields that will give me an overall status of the 3.

Text Field 1
Text Field 2
Text Field 3

If Text Field 3 is populated I want to capture that entry, if it is blank then I want to read Text Field 2 and populate that entry. 

If Text Field 2 is blank then I want to read Text Field 1 and populate the entry.

Everything I've tried so far only gives me the info if Text Field 3 has data.

Does anyone have insight?

Thanks
Sheila

------------------------------
Sheila Allas
------------------------------

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    np, 
    Quickbase executes an IF in sequence looking for the first condition which is true.
    Unlike Excel, you only need one IF for most formulas

    IF(
    Trim([Text Field 1])<>"", Trim([Text Field 1]),
    Trim([Text Field 2])<>"", Trim([Text Field 2]),
    Trim([Text Field 3])<>"", Trim([Text Field ]))

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • SheilaAllas's avatar
      SheilaAllas
      Qrew Trainee
      2 years ago
      Thank you!  Works perfectly!

      ------------------------------
      Sheila Allas
      ------------------------------