Skip to main content
Question

Formula Help Needed

  • January 30, 2023
  • 0 replies
  • 41 views
Forum|alt.badge.img+4
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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement