I’ve a Google Sheet the place the customers are constructing a reputation in a column primarily based on content material entered into earlier columns. I have to restrict the output of the formulation to 128 characters (limitation of names in Vimeo). I used to be questioning what’s one of the simplest ways to alert the consumer that the video title they’re creating is longer than 128 characters and that they should shorten it. Is there any formulation the place the variety of characters could possibly be counted, and if the overall characters had been greater than 128 characters there could possibly be some method to let the consumer know what number of characters they’ve exceeded 128 characters by? That will be very helpful to the particular person creating the title. I am unable to permit a reputation longer than 128 characters to be created.
The three completely different formulation I’ve used throughout three completely different sheets are:
=ARRAYFORMULA(IF($E2:$E=”Sure”, $D2:$D, IF(ISBLANK($A2:$A), “”, $A2:$A & ” – “) & IF(ISBLANK($B2:$B), “”, $B2:$B & ” – “) & IF(ISBLANK($C2:$C), “”, $C2:$C & “. “) & $D2:$D))
=ARRAYFORMULA(IF(ISBLANK($A2:$A), “”, $A2:$A & ” – “) & IF(ISBLANK($B2:$B), “”, $B2:$B & ” – “) & IF(ISBLANK($C2:$C), “”, $C2:$C & “. “) & $D2:$D)
=ARRAYFORMULA(($A2:$A & ” – “) & $B2:$B)