#UNPARSEABLE for Column "IF" Formula

Options

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 #.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!