there is no such limit.... there must be spell error or lack of "else" or something in the formula... there is no limit to number of conditions in the formula
If there are too many IF(s) they all are checked thus making tally to respond slow! I feel you may, try SWITCH instead, but then you will have to make optional fields but that will be one time activity and thus will improve the reusability and speed.
Split it up.......... [System: Formula] myOwnColor : if $vTallyColoursv:Ledger:$PartyLedgerName = "Red" then "Red" else + if $vTallyColoursv:Ledger:$PartyLedgerName = "Blue" then "Blue" else + if $vTallyColoursv:Ledger:$PartyLedgerName = "Green" then "Green" else + if $vTallyColoursv:Ledger:$PartyLedgerName = "maron" then "maron" else + if $vTallyColoursv:Ledger:$PartyLedgerName = "orange" then "orange" else + if $vTallyColoursv:Ledger:$PartyLedgerName = "AmericanRose" then "AmericanRose" else + if $vTallyColoursv:Ledger:$PartyLedgerName = "PowderedBlue" then "PowderedBlue" else + if $vTallyColoursv:Ledger:$PartyLedgerName = "Coral" then "Coral" else + if $vTallyColoursv:Ledger:$PartyLedgerName = "CandyApplegreen" then "CandyApplegreen" else + if $vTallyColoursv:Ledger:$PartyLedgerName = "RosyBrown" then "RosyBrown" else @@myOwnColor2 myOwnColor2 : if $vTallyColoursv:Ledger:$PartyLedgerName = "MediumPurple" then "MediumPurple" else + if $vTallyColoursv:Ledger:$PartyLedgerName = "AzureMist" then "AzureMist" else + if $vTallyColoursv:Ledger:$PartyLedgerName = "Darkpink" then "Darkpink" else "black"
as it is...... @@myowncolor............. once it exhaust myowncolor it will go to 2nd, then 3rd read the formula once again carefully....at the end it goes to second formula...and so on. So you need to specify only...... @@myowncolor.