Leading Zeros and Alpha Numeric Sorts

Anyone Know how to write a formula to always add a "0" if its only 1 digit?

Example I want the below to day "04"

Kyle Bonde - Vertical GC 7d 0h

wow love chat gpt helped me! All you have to know is zzTO uses math.js and can solve many of your problems. Here is what I used:

concat(if([width:IN] < 10, "0", ""), string([width:IN]), '"')

Lorin Allred zzTakeoff6d 23h

Awesome!! Glad you figured it out, and thanks for sharing. 🙂

Justin Gueli 6d 20h

Glad you figured it out Kyle. I've told a few users on here that having some sort of AI service is a HUGE help with formulas.

You must be logged in to post replies. If you don't have an account you can signup here.