I am using Table Builder to create a report, however I do not want the end user to be able to see custom Excel formulas such as =IF statements.
Keep in mind that I have NP("Formula") before the IF statement so I am not sure why I still see the IF statement in the edit bar. All other NL() functions only show the resulting value which is what I want. However, with NP() functions if still gives the formula.
Does anyone know how to hide this formula? Additionally, I have also tried the NP("EVAL") function but it takes the result of the first row and copies it down because as you know NP(EVAL) breaks the connection with the formula to paste the result.
I am looking forward to your feedback. Thanks in advance!!
