Discussions

 View Only
  • 1.  Formula Help Needed

    Posted 01-30-2023 13:27
    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.  RE: Formula Help Needed

    Posted 01-30-2023 13:56
    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
    ------------------------------



  • 3.  RE: Formula Help Needed

    Posted 01-30-2023 15:55
    Thank you!  Works perfectly!

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