Anyone know how to create a random color hex code? Preferably unique to the table…
@Grant_Stead I think this will work in excel/sheets:
=DEC2HEX(RANDBETWEEN(0, 256^3), 6)
Might be a good starting place.
In case anyone stumbles on this, here’s what I did. I’ve got appsheet dropping in an initial RANDBETWEEN(0, 16777215) so that it stays fixed… Then I’ve got an array formula on the google sheets side to convert it to HEX color code. =ARRAYFORMULA(IF(ROW(AN1:AN)=1,“people_hex_color”, IF(ISBLANK(AN1:AN),DEC2HEX(AN1:AN, 6))))
I can make custom icons, by building a concatenated URL. This also gives me the ability to have unique colors for each person, that way if they make comments, etc. You can tell whom it is at a glance. ImgPlaceholder.com imgplaceholder.com