Which Formula you never use?

[diogolupcosta]

Just to unwind and chill:
Witch formula you do not use (or don't master it) and run away from it in your expressions?

I have to admit, mine is: LOOKUP() 😜

[SkrOYC]

LOOKUP() as well, I just haven't had the need.

Same for any "machine learning" ones extracting phone numbers, addresses, etc, advance math operators, and those USERNAME(), USERROLE(), I prefer a dedicated UserTable 😉

[1minManager]

Yeah I'd agreed that LOOKUP() and FILTER() I almost never use.  I sort of prefer the greater flexibilty you get with SELECT().  Though I have started using MAXROW() abit recently.

I also agree with @SkrOYC that I mainly use a user table to define a users permission levels.

[SkrOYC]

---

@1minManager wrote:

FILTER() I almost never use.  I sort of prefer the greater flexibilty you get with SELECT(). 

---

That's interesting. I use Filter() a lot compared to Select().
Since Select() has a third argument, does this add a little overhead to our apps when it's use on a SELECT(Table[Id], XXXX, true/false) compared to FILTER(Table[Id], XXXX)? 🤔

[Steve]

FILTER() is just a wrapper for SELECT(), as are LOOKUP(), MAXROW(), MINROW(), and REF_ROWS().

[Steve]

I don't use any GCAL, machine learning, and non-trivial math functions.

I use USERNAME(), USERROLE(), all the query functions, conditionals, and logical functions a lot.

[SkrOYC]

Snapshot(), that's one that I don't even know why exists 😅

Just reviving this funny post

[diogolupcosta]

It´s useful to print views (i never use it too). I use printnode api