Filter syntax with specific user

PHOTO

Sun Feb 16 2025 09:26:11 GMT+0000 (Coordinated Universal Time)

Saved by @Wittinunt

AND(
  OR(
    ISBLANK(LOOKUP(USEREMAIL(), "Revenue Filters Slice", "User", "From")),
    LOOKUP(USEREMAIL(), "Revenue Filters Slice", "User", "From") <= [Date]
  ),
  OR(
    ISBLANK(LOOKUP(USEREMAIL(), "Revenue Filters Slice", "User", "To")), 
    LOOKUP(USEREMAIL(), "Revenue Filters Slice", "User", "To") >= [Date]
  )
)

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

AppSheet

@Wittinunt

Grant access rights to user email Force go to some view then sync Filter syntex Find unique then put each sigle one to each row Find uniques Select the last row value SUM multiple conditions OrderBy from different tables Add a new line in between list items Filtering with specific email AppSheet Select All Find uniques for a slice Filter syntax with specific user

Browse more snippets >>