#UNPARSEABLE for Column "IF" Formula
I get an #UNPARSEABLE error for the following formula and am not sure what I'm doing wrong:
=if([Destination]@row] = [Source]@row, [Destination ID #]@row, "")
Where the destination = source, the destination ID should be entered. Otherwise, I want to leave the cell blank so that someone can manually enter the ID #.
Best Answer

I just saw the error: an erroneous bracket was after "[Destination]@row" It should be:
=if([Destination]@row = [Source]@row, [Destination ID #]@row, "")
Answers

Do you have a screenshot of the the column headings, and the field which contains the formula?

I just saw the error: an erroneous bracket was after "[Destination]@row" It should be:
=if([Destination]@row = [Source]@row, [Destination ID #]@row, "")
Help Article Resources
Categories
Check out the Formula Handbook template!