Hi- I am encountering this error message in formula tool attached below and could someone please help and let me know how I can fix it? Thank you!
Solved! Go to Solution.
You need to put "ELSE [ID] ENDIF".
In the Else clause, it's necessary to mention the field.
Cheers,
Thank you!. That helped. But now I have added [ID].
It shows error of 'Type mismatch. where string is required.'
Any idea why?
I attached the workflow below. Thanks again!
You're misusing the TRIMRIGHT function.
TrimRight(x, y): Removes character in the string y from the end of the string x. Y is optional and defaults to trimming white space
The "Y" argument needs to be a string, you put a 2 over there.
Cheers,
I'm not so sure what you're trying to do, but you could use this:
Replace([ID], "ID", "")
Cheers,