FilterByFormula IF syntax


I’m trying to use the API encoder to find if a value exists using filterByFormula, and in response get a certain string if it exists and another string if it doesn’t.

This is where I’m at but it seems it’s not the direction
IF(FIND(“5z”,{Field 6})=0, “DOESNT”, “EXISTS”)

Any ideas?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.