Skip to main content
Question

There are extra characters beyond the end of the formula.

  • Dec 3, 2023 5:20 PM UTC
  • 0 replies
  • 283 views

I can't for the life of me figure out why I'm getting this error. My formula is 214 lines. I added it as an attachment since it's so long. 

Any assistance would be appreciated. 

Also, what is the significance of the of where they highlight the error because it honestly seems arbitrary (I know it's not). 



------------------------------
Ji Kim
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+1

The problem here is you are using a fresh IF statement for each line, when in Quickbase you shouldn't do that.

You should enter the formula this way:

"IF([Main Processing Unit]="Retirement Services","",

[Main Processing Unit]="0000202 AVAYA","0000202 AVAYA",

[Main Processing Unit]="0000250 CWA PAYERS NO CNTRCT-ATT LEGACY","0000250 CWA PAYERS NO CNTRCT-ATT LEGACY",

....

[Main Processing Unit]="Carolyn Williams","","")

So on every line except line 1 you need to remove If(

And on every line except the final line you need to remove the "")

Once you do that it should all work.

The formula highlights the first instance of an error it finds, not every error in the formula. so when you fix one, it may highlight another error further along.



------------------------------
Personal Tax Team
------------------------------