Text Formula Field Error

Question

Hello once again.I am probably looking right at it, but I can't seem to find my formula error.Please see pop-up message below:Text Formula Field ErrorFormula syntax errorPlease check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.If([Cost Code]&lt;&gt;"",[Cost Code] [Cost Code]="",[Building Group Identifier] &amp; [Record ID#])Your critical scrutiny is appreciated.Dirk------------------------------Dirk Ruana------------------------------

katherinecarot2 · Answer

Hi Dirk,&nbsp;You are missing a comma after the second second cost code. You also don't really need the "Cost Code=""".&nbsp; The first condition you are testing is whether cost code is not blank, so if that is true it will return cost code. If that condition is false, (the false condition being that cost code is blank), it will return [Building Group Identifier] &amp; [Record ID#].So you could write it as - if the cost code is not blank, cost code, otherwise building group identifier and record id. If([Cost Code]&lt;&gt;"",[Cost Code],[Building Group Identifier] &amp; [Record ID#])I hope that helps! Katherine------------------------------Katherine Carothers------------------------------

dirkruana · Answer

Thank you Katherine!------------------------------Dirk Ruana------------------------------

Forum Discussion

Text Formula Field Error

2 Replies