Skip to main content

FilterByFormula IF syntax

  • October 30, 2020
  • 0 replies
  • 3 views
T
  • tom_bg
  • New Participant
  • 3 replies

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

Be the first to reply!


Terms & ConditionsAccessibility statement