Concatenate 2 numbers

M Johnston

I want to concatenate 2 numeric columns into another numeric column. Taking Year and Month into YEARMONTH where YEARMONTH is still a number and not text. 2023 and 07 as number 202307

Andrée Starå

https://community.smartsheet.com/discussion/123289/concatenate-2-numbers

Hi,

I hope you're well and safe!

Add VALUE before the concatenation to convert it to a number.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Andrée Starå

https://community.smartsheet.com/discussion/123289/concatenate-2-numbers

Hi,

I hope you're well and safe!

Add VALUE before the concatenation to convert it to a number.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

M Johnston

Any chance to get the formula? :o) My join is below.

=if([Tr Month]@row < 10, JOIN([Tr Year]@row:[Tr Month]@row, 0), IF[Tr Month]@row > 9, JOIN([Tr Year]@row:[Tr Month]@row)

M Johnston

Got it! Just put in front of the JOIN with a ( as VALUE(JOIN(…

Andrée Starå

https://community.smartsheet.com/discussion/comment/440661#Comment_440661

Sure!

Try something like this.

=IF([Tr Month]@row < 10, VALUE(JOIN([Tr Year]@row:[Tr Month]@row)), IF([Tr Month]@row > 9, VALUE(JOIN([Tr Year]@row:[Tr Month]@row))))

Did it work?

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

M Johnston

It worked great!

Andrée Starå

https://community.smartsheet.com/discussion/comment/440682#Comment_440682

Excellent!

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!