I’ve a Google Sheet the place an array components in Column I creates a video identify primarily based on the content material entered into columns A+B+C+D. Column C is the variety of the video. For some movies, I want a number one zero within the identify and for others, not. I do not wish to format column C as textual content – I want to go away this column formatted as a quantity. I additionally needed to format Column C so as to add a full cease after the quantity as it will be significant that is a part of the quantity within the identify. I can not depend on editors to at all times keep in mind so as to add the total cease.
What do I add to the array components so it accurately displays the content material in Column C, the place some movies could have a number one zero (like 01. and a few not, like 0.)
=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))
Right here is my Google Check Sheet.