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 ...
Forum Discussion
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
------------------------------
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
------------------------------
- Thank you! Works perfectly!
------------------------------
Sheila Allas
------------------------------
