Here I am trying to add a random hexadecimal value every time a name is entered. It’s working but the other empty cells get filled with false
.
I want to completely delete the false part as it’s causing problems while automation.
I have tried replacing the false
with an empty string but my automation software still skips those rows.
Please help!
My formula to get hexadecimal values:
=ARRAYFORMULA(IF(len(A2:A),DEC2HEX(RANDBETWEEN(1,16*sign(row(A2:A))),4)))
Best Answer
add one more
,
like: