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.

Rod Finch
Rod Finch
edited 12/09/19 in Archived 2016 Posts

Hi there,



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.



This discussion has been closed.