Formula Help Needed

Question

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
------------------------------

markshnier__you · Answer

np,&nbsp;Quickbase executes an IF in sequence looking for the first condition which is true.Unlike Excel, you only need one IF for most formulasIF(Trim([Text Field 1])&lt;&gt;"", Trim([Text Field 1]),Trim([Text Field 2])&lt;&gt;"", Trim([Text Field 2]), Trim([Text Field 3])&lt;&gt;"", Trim([Text Field ]))------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

sheilaallas · Answer

Thank you!&nbsp; Works perfectly!------------------------------Sheila Allas------------------------------

Forum Discussion

Formula Help Needed

2 Replies