I’ve a Google Sheet the place an array method in Column I creates a video identify based mostly 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 need to format column C as textual content – I want to depart 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 can be crucial that is a part of the quantity within the identify. I can not depend on editors to at all times bear in mind so as to add the total cease.
What do I add to the array method so it accurately displays the content material in Column C, the place some movies can 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.