Hello all,
Im using Smartsheet to automatize a lead process with around 30 people involved. We get Leads in an external network, I add them to my Smartsheet Sheet and then the one in a contact column gets an automatized notification with the new lead data. After 5 days I need an update with est. values and so on, so I made a column with a formula that gives out a 1 if it is 5 days after the initial notification and 0 if not. If it is 1, then an automatized update request is sent to the one responsible to give me the values I need for my reportings.
Now to my setup: I made the update request rule as follows: trigger when a row is updated, then check if the column with the 1 and 0 in the "5 days after initial notification" is 1. Afterwards check if the Columns with the needed Values are empty. Then send the update request to the Person in the contact column Responsible.
Now the problem: as the rule only starts if a row is updated it does it when the "5 days after initial notification" column changes to 1, but also if anyone updates their values in their rows per update requests. So now the Team gets more than one update request for the same row, if somebody updates their rows in the same day.
Do you have any ideas if it is possible to make a new trigger with the formula: IF there is an update request in the row do not send any other update requests?
I changed the delivery right now to only once per day, had it to imediately before. But dont really know if it will help.
Kind regards
Arnis
