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.