JOIN in Automation Adds a '

scottg.lexia

Hello,

I'm trying to setup a basic automation to join two columns. Each is a basic text field containing two different labels/tags. I want to combine them into a single string so I can send them through a JIRA connector. I can get the formula to work outside of the automation but when I try to setup a basic automation using "change cell value" and entering the formula into the value, it automatically adds a ' at the start of the formula which prevents the formula from actually running. Given the number of folks that recommend using a JOIN in an automation, I'm assuming I'm missing something on how to actually insert the JOIN via automation. Should I be using a different action or..?

~Scott

John_Foster

Hi @scottg.lexia

I have been looking at this for you and found this article that maybe able to help you.

https://community.smartsheet.com/discussion/86494/add-a-formula-to-a-cell-using-automations

Regards,
John