NSC | Resolve Error: "Field Not Found" when Copy-Pasting formula from SuiteAnswers

Scenario

User creates a saved search and is copy-pasting the formula provided in SuiteAnswers. However, when the search is ran, it returns ERROR: Field Not Found for that column.

Solution

Normally, if a copy-pasted formula doesn't work, it means that there is something wrong (like incorrect spelling or symbol) or something missing (like parenthesis or comma).

Some might have encountered this before with the apostrophe and single quote symbols. If the formula was typed in MS Word wherein the ' symbol is treated as an apostrophe, and is considered invalid in SQL formula (single quote symbol works).

But if those were already ruled out, then there might be a