Having issues with the SEARCH function, try using REGEXMATCH. Just remember that the parameters for this function is reverse of the SEARCH function. The SEARCH function will sometimes through an invalid value error message (Invalid Formula: #VALUE) even though the expression is correct. Comments from one of the support team members indicate “that sometimes the search function gets a little over aggressive where it will fail a formula that is written correctly, simply because there is not data to match it up with”.
1 comment on “Using REGEXMATCH in Scribe”