Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

If & Len

Can anyone tell what is the issue in this formula?   Trying to extract the numbers then after looking at the first digit assign valid or invalid status using it in custom column in editor if (Tex...
  • HotChilli's avatar
    HotChilli
    4 years ago

    Text.Start takes 2 parameters.

    5 is not a text value.

    That's my initial thoughts.

    Break it down to get it working, then build it back up

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

Text.Start takes 2 parameters.

5 is not a text value.

That's my initial thoughts.

Break it down to get it working, then build it back up

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Yes i was missing the second parameter of count.