If Blank without need to copy everything to the if false value

1

I am trying to return a 0 if a whole operation is blank, its long enough to copy and paste it again in the false value, any alternatives?

2

You can use WithName() to give a name to a bunch of formula code.

Somecomplicatedstuff().blabla.etc().WithName(
  MyStuff,
  If(
    MyStuff.isBlank(),
    0,
    MyStuff
  )
)

This takes your complicated code, gives it the name “MyStuff”, and then you can use MyStuff to reference that result in multiple places.

2 Likes
3

thanks! I managed to do th formula

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.