Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Turning "=year" value into 2 digit number and "=yearday" value into 3 digit number.
With "=year()" function, I can get the year in 4 digit numbers and with "=yearday()" formula, I can get the day in 1 to 3 digit numbers.
However, I am trying to combine them into 5 digit number ("YY" + "DDD") to automatically generate julian date.
Since Smartsheet doesn't have the "=text()" function, I am not so sure how to do that.
I would very much appreciate if anyone can provide me with some feedback.
Thanks in advance.