General Discussions

Discuss any topics that are not product-specific here.

To Limit the Digits inside Column

selinunlu
7 - Meteor

hello everyone,

 

I want to limit digits in columns. Firm name can be max 72 digit and tax number should 10 or 11 but there are many numbers with 9 digits.So which formula should be used for this?

 

 

selinunlu_0-1647451178646.png

 

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @selinunlu 

 

If you want to only check you can do like below.

 

atcodedog05_0-1647451996943.png

 

 

Hope this helps : )


Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

selinunlu
7 - Meteor

Thanks for help.

 

I couldn't get this. I want to see whole text in the  firm name check column. For example, if firm name AAAAAAAAAAB less than 72 digit I want to see all inside the cell but if it is higher than 72, I want to see the name till seventy-second digit.

Sincerely.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels