Number ID on text column being automatically rounded up when using in formula

1

I have a TEXT column with a number ID. I made the column text to avoid these weird rounding quirks, given I am dealing with an ID number that has to be exact to be correct. I need a display column that displays several information from other columns as text string. The issue is that specifically for the ID number it appears to insist on rounding it up.

image
image528×114 6.45 KB

The formula I am using in the Display column is:

List(
  thisRow.Payee,
  If(thisRow.Bank.IsNotBlank(), "Banco: " + thisRow.Bank, ""),
  If(thisRow.ID.ToText().IsNotBlank(), "ID: " + thisRow.ID.ToText(), "")
)
.Filter(CurrentValue.IsNotBlank())
.Join(Char(10))

Any help on how to avoid this?

2

next time, please add sample doc. anyway you can try this:

List(
  thisRow.Payee,
  If(thisRow.Bank.IsNotBlank(), Format("Banco: {1}", thisRow.Bank), ""),
  If(thisRow.ID.IsNotBlank(), Format("ID: {1}", thisRow.ID), "")
)
.Filter(CurrentValue.IsNotBlank())
.Join(LineBreak())
3

Oh, sorry. I’ll keep it in mind next time.

This works, thank you very much :slight_smile: