Functions for synchronizing Predecessors and Jira Issue Links
Hi everybody,
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!
Answers
-
Hi @theilm
Would you be able to post a screen capture of your sheet and perhaps explain what you're looking to do with an example?
I would potentially have this formula in a second, helper column - set as a column formula. You could add an IF statement at the front if you only want the formula to populate based on a specific status or date, etc.
This helper column won't be synced with your Issue Links field in Jira, but you could set up a new, custom field in Jira to receive it.
If you have access to Pro Desk, you could book a 30-minute coaching session over screen share on "Connectors, Premium Apps, & Extended functionality" to walk through the best way to sync these fields.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!