Silly Admin Trick: Checkbox Formula

Hardly worth posting but never knew that if you just do a formula like “len(name) > 10” works the same as if you did “if(len(name) > 10, TRUE, FALSE)”. Silly shortcut but kind of cool! I found this while doing my favorite hobby…data cleanup and the case of the ‘who loaded the bad data!’.

Leave a Reply

Your email address will not be published. Required fields are marked *