Convert numbers to text & concatenate

Eric H
Eric H
edited 12/09/19 in Formulas and Functions

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!