Resolving Unintended Webhook Triggers Due to Formula Updates
Hi Smartsheet Community,
I'm encountering an issue with my webhook setup and seeking your insights. My webhook is designed to monitor changes in two specific columns: 'Start Date' and 'End Date'. It's set up to trigger a calculation that updates certain data in Smartsheet when a change is detected in these columns.
However, I've recently observed that my web server and Smartsheet are receiving updates via the API even when there are no direct changes made to these two columns. Upon investigation, I discovered that the 'End Date' column is involved in a formula that updates multiple rows. This seems to inadvertently trigger the webhook, despite there being no manual change in the 'End Date' data itself.
My understanding was that the webhook would be activated only by actual changes in the row's data. Is there a way to refine the webhook's trigger conditions to avoid these unintended activations? Specifically, I want the webhook to respond only to manual changes in the 'Start Date' and 'End Date' columns, and not to updates caused by formula recalculations.
Any advice or suggestions on how to address this issue would be greatly appreciated.