Convert numbers to text & concatenate
Hi all, I'm new to Smartsheets and hit a bit of a wall. I need to put task due dates in a 30-60-90 designation. That 30-60-90 is set one time at the beginning of the month so it's not dynamic. I thought my best bet would be to build a column designated YYYYMM to do any month math for the rough 30-60-90 column. I figured out how to extract the year and month from the due date but I can't find the convert to text and concatenate functions. What am I missing?
Help Article Resources
Check out the Formula Handbook template!