Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Smartsheet-JIRA sync via formulas?
Hi guys. I'm using the Smartsheet-JIRA connector. I have a workflow where the Status of each JIRA ticket flows back into Smartsheet. Then formulas in Smartsheet change the Priority of a row once its predecessor is complete. The idea is that you have a bunch of tickets in JIRA that are marked as priority Blocked if they have an uncompleted predecessor, and the priority in JIRA automatically changes once the predecessor is Done.
I set up the formulas in Smartsheet correctly - everything works on that side. However, it appears that the connector only syncs when you make changes in Smartsheet and SAVE a new version. I want to have the connector sync when any of the Smartsheet formulas update, even if the Smartsheet isn't even open. Is that possible?