Multiple Character delimiter in formula
I'm trying to cut out the last 5 digits of a Serial Number if the length is greater than 11, and I'm also trying to add a - after the third digit if the type is set to Master... What I have so far: ...
Forum Discussion
With the formula you posted above - it returns the following:
So looks like it's behaving as expected? When Type = "Master", the prefix is 123, with mini being 4567890.
------------------------------
Xavier Fan
Quick Base Solution Provider
http://xavierfanconsulting.com/
------------------------------
So looks like it's behaving as expected? When Type = "Master", the prefix is 123, with mini being 4567890.
1) With Number = 1234567890, Type = "Master"
Result = 123-4567890
2) With Number = 1234567890, Type <> "Master"
Result = 1234567890
------------------------------
Xavier Fan
Quick Base Solution Provider
http://xavierfanconsulting.com/
------------------------------