195d 8h
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 195d 8h
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 zzTakeoff195d 7h
Awesome!! Glad you figured it out, and thanks for sharing. 🙂
Justin Gueli 195d 4h
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.
👍1 You must be logged in to post replies. If you don't have an account you can signup here.