Functions for synchronizing Predecessors and Jira Issue Links
I am currently trying to set up the smartsheet-Jira-integration. A lot of things really work great but there is one thing.. I want to have Smartsheet as the "leading tool" for handling of predecessors and therefore sync this information to Jira through the issue links field.
To give a simple example, I used
="is blocked by " + INDEX([Issue Key]:[Issue Key], VALUE(Pre@row))
for the filed "Issue Links".
But what I would like to achieve is that I do not overwrite exisiting issue links of the corresponding issue. I was hoping I can achieve this through automation but without being able to use formulas in "change cell value" I cannot append information.
Any ideas how I can achieve what I want?
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!