Navigate URL Automation

amkumar81861

Hi Team, 

Is it possible to automatically navigate to a URL added in a cell if specific cell value changes to specific value?

Please see below to understand the requirement.

I have a tracker sheet for each project. Each tracker sheet having multiple task and once all task completed a formula cell shows to project completed 100%. I also have a tracker in different application that need to be updated only date of project completion. And I can achieve this by clicking on a URL. So if smartsheet is able to navigate URL on 100% completion of project. Other application will take data automatically and we can save lot of efforts.

 

Andrée Starå

Hi Amkumar,

The third-party service, Zapier might be an option for this scenario. Is that an option for you?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 

amkumar81861

Andrée,

I don't actually want to go for any third party apps. What we need is to develop inhouse. I have to update a field in Salesforce, I have developed interface using API of smartsheet and salesforce. But I am not able to integrate it in real-time. If there is feature in smartsheet to navigate link without any user interaction on status changes like alerts and approval works, Please let me know.