If Formula Help with commas
I've got an If formula that is working, but I need to only have the first comma before the next line to show only if there is text in the next field. Here's my formula: (If([Grant Acct.]<>"", [Gran...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI suggest that you re-work your formula to use the List function. This will separate non blank fields with a separator string that you specify.
here is the help text on the List Function.
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=152&rl=fp
I think that you want something like this.
List(",\n\n",
List("-", [Grant Acct.], [GL Code], [Function Code], [Department Code], [Future Code]),
List("-",[Grant Acct. 1], [GL Code 1], [Function Code 1], [Department Code 1], [Future Code 1]),
List("-",[Grant Acct. 2], [GL Code 2], [Function Code 2], [Department Code 2], [Future Code 2]),
etc
List("-",[Grant Acct. 5], [GL Code 5], [Function Code 5], [Department Code 5], [Future Code 5])
)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
here is the help text on the List Function.
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=152&rl=fp
I think that you want something like this.
List(",\n\n",
List("-", [Grant Acct.], [GL Code], [Function Code], [Department Code], [Future Code]),
List("-",[Grant Acct. 1], [GL Code 1], [Function Code 1], [Department Code 1], [Future Code 1]),
List("-",[Grant Acct. 2], [GL Code 2], [Function Code 2], [Department Code 2], [Future Code 2]),
etc
List("-",[Grant Acct. 5], [GL Code 5], [Function Code 5], [Department Code 5], [Future Code 5])
)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
