Convert numbers to text & concatenate

Eric H

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?

Andrée Starå

Hi Eric,

Not sure I follow!

Do you want to add 30,60 or 90 days to dates?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Eric H

Thanks for responding, Andree. I need the due date to fall within 30, 60 or 90 day plan. That 30,60,90 deliverable changes at the first of the month. I think I can figure out how to do it if I can figure out how to combine the YYYY and the MM into a single value for each row (e.g. 9-24-19 would be 201909).

Andrée Starå

Happy to help!

I'm still not clear on what you exactly want to do but here goes!

If you want to add 30,60 or 90 days to a date, you could use something as simple as this: =Date@row+90 You could also have a separate column with the numbers in a dropdown list, and that would look something like =Date@row+Days@row

Would that work?

Hope that helps!

Here are some resources for the function JOIN and DATE. (in case that's what you need instead)

https://help.smartsheet.com/function/join

https://help.smartsheet.com/function/date