Question:
Hi folks,
When I create the following formula in update rules, I get the error message that the formula is syntaxically correct but incomplete. I tried to close this formula with a "." as well as ")". Still it is not accepting. I need somebody to help me.
IF( /BIC/Z_OPENQT = 0, /BIC/Z_STATUS = "closed"
Thanks.
Answer:
IF( /BIC/Z_OPENQT = 0, /BIC/Z_STATUS = "closed"
.
Try the following:
IF( /BIC/Z_OPENQT = 0, /BIC/Z_STATUS = "closed", )
The syntax is the same as in Excel:
IF(CONDITION, action if condition is true, action if condition is false)
Answer:
Thanks Frank for your reply. But it does not work and it comes with the same error message that formula element is not expected here.
Answer:
Maybe the problem is that you should make an entry for the false statement. Something like:
IF( /BIC/Z_OPENQT = 0, /BIC/Z_STATUS = "closed", /BIC/Z_STATUS = "open")
Other problems might be (depending on your settings):
* Do not use , but ; to separate the different statements. Check this be selecting the IF statement at the bottom of the screen. The empty syntax is shown in the definition screen
* Do not use " but use '