Tag: VALUEIN()

  • About VALUEIN() in ER for filtering lists

    About VALUEIN() in ER for filtering lists

    In this post, I’m going to experiment with the VALUEIN() formula inside FILTER() to better understand how it really works. VALUEIN() is a formula that returns a boolean indicating if a certain value is in a list. For example, if we want to know if ‘US-001’ is in the ‘CustTable’, we would do: And we’ll…