Hi There,
I'd like to set a custom field value that is the first 6 characters of the item id.
This formula works in Saved Searches:
substr({itemid},1,6)
However upon using the same formula in workflow to set this value when Item ID is edited, it doesn't seem to work. Can anyone help?
Thanks!