I am trying to create a field for our task table header that will combine two fields
For example - Client Name and Transaction Name.
The issue is that some records have a client name and transaction name and some will have one and not the other. So I need the formula to look if the field and display either both or the one that has data.
If ( >" ", ),
//if ([Contact - Full Name] >" ", [Contact - Full Name])
The fist line of code works, I cant seems to get the right syntax to combine them into the new field
Thanks.
------------------------------
EF
------------------------------
Solved
Simple If Statement Syntax
Best answer by MarkShnierYou
Try this
List(" - ", [Transaction Name], [Contact - Full Name])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
List(" - ", [Transaction Name], [Contact - Full Name])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.