Counting Decimal Places

[Danny_Pettiona]

Hey all,

Pretty simple one here - is there a formula I can use to count the number of decimal places?

Use case:

I run a project management table, the parent - child 1 - child 2 - child 3 relationship is based on decimals.

I.e.
Parent = 1
Child 1 = 1.1
Child 2 = 1.11
Child 3 = 1.111

If there was a second child 2 for example it would become 1.12.

Thanks in advance!

[Christiaan_Huizer]

something like this @Danny_Pettiona :

Best, christiaan

[Danny_Pettiona]

Legend thanks Christiaan

[Breno_Nunes]

Hey, @Christiaan_Huizer and @Danny_Pettiona

Correct me if I’m wrong but I don’t think that formula works for every case.

This is how I would extract the trailing zeros to get the right number

[Christiaan_Huizer]

hi @Breno_Nunes
thanks for jumping in!
you are right, the moment you consider a zero as an option between other numbers, your solution is the way to go. In my understanding that was not the set up, but in case I am mistaken, your suggestion is indeed an improvement!
cheers, christiaan