Hello Community,
I try to find a solution to validate the length of a column by allowing maximum 50 characters in a cell, those which not met criteria would be excluded in the False Anchor (perhaps using filter formula?)
I am pretty new here and did not find yet a formula to count characters within a cell..
Thank you!
Solved! Go to Solution.
hi @Tmanuela try using the "length" expression in the formula tool. this gives you the amount of characters in a particular field. then use the filter to exclude anything over 50 in the "length" field
Hi @Greg_Muray ,
Thank you very much, was that simple!
Manuela
Thank you very much, @Emil_Kos. This was really helpful.
However, don't know why @ mention is not working though..
Manuela