Anyone else running into this? I have the following formula (encoded or not) that throws an INVALID_FILTER_BY_FORMULA error when submitted to the API via JavaScript:
AND(IF(FIND(‘GIZELLE’S BUCKET LIST’, Available_Rights) > 0, TRUE(), FALSE()))
The on...
Hey, guys -
Thanks for all of this great info - the formulas have been very helpful! The First Name extractor as written returns “Jo” from the string “Jo Ann Doe”. For the life me, I can’t seem to wrap my head around how to get the formula to return...
