Not sure if you can limit the number of character in a text field (you can use conditionnal formating to check if you are too long, but may be not limit.
Anyway, if this is an issue of display, you can have a “Long Caption” column, where you write anything you want, and use a “Display Caption” that will show a limited number of character, and use this column for display purpose. For that please use Slice() function :
It still requires me to have a separate column but for my use case, it least, it will safe guard me from exceeding character limit as now I can only use view where it shows the formula column as caption column.
Yes that’s it. But be careful, that wont be in live, you must enter/validate your text for the conditionnal format to apply. As long as you have the cursor as if you’re still writing, the cell won’t turn red even if you exceed the limit