Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

FilterByFormula IF syntax

Topic Labels: API
1027 0
cancel
Showing results for 
Search instead for 
Did you mean: 
tom_bg
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

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?

0 Replies 0