Forum Discussion
Token Comma Expected Error
Hello, I'm trying to run the following formula in a custom column and its generating a token comma error. Can anyone review and let me know what's missing? Thanks! IF([Primary Home Addre...
This the correct syntax
IF([Primary Home Address Line 1]<>[OG Census_Sheet.Primary Home Address Line 1] or [Primary Home Address Line 2] <> [OG Census_Sheet.Primary Home Address Line 2] or [Primary Home Address Line 3] <> [OG Census_Sheet.Primary Home Address Line 3] or [#"Primary Home Address - City"] <> [#"OG Census_Sheet.Primary Home Address - City"] or [#"Primary Home Address - State"] <> [#"OG Census_Sheet.Primary Home Address - State"] or [#"Primary Home Address - Postal Code"] <> [#"OG Census_Sheet.Primary Home Address - Postal Code"] , "true" , else)
Thank you for the quick response. When I use your solution it shows an error 'Token Literal expected' with the closing parenthesis after 'else' marked.