Cancel reoccurring update requests when complete (or 100%)

Mikey

Hi All,

I might be missing something, but I want my reoccurring update requests to automatically stop sending when the activity they relate too reaches completion.

Anybody know how to do this?

Appreciate any guidance you can give me.

Mike

Mike Wilday

Hi Mike, It would be helpful if we knew how you set up the recurring update. Did you do it through the alerts and notifications or did you do it through the row options? 

Andrée Starå

Hi Mike,

I haven't had time to test this out but maybe it would work with the new lock row functionality.

Set a rule that when it's 100% lock the row and that will probably stop the update request because nothing can be changed anymore. 

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

 

Shaine Greenwood

Hi Mikey,

If you're using an automatic update request, try adding a condition to your rule that will only send the update request when % complete is < 1 (which means less than 100%, as percentages are treated as decimal values in Smartsheet).

Jerry Tutt

Hi Shane,

This is a great idea but, I don't see anywhere that I could enter a rule.  I can set a reoccurring update request for weekly and for Monday and for a given time.  But, I don't see where there is an option to add a condition or rule.  

Jerry

Jerry Tutt

Hi Shane,

 

I think that I would need to upgrade to automated actions to be able to do what you suggest and add a rule or condition.  I'll have to investigate the associated cost to see if it is worth it.  

Thanks again,

jerry

Shaine Greenwood

Hi Jerry,

You're correct in that you may need to upgrade—automated actions is available for Business and Enterprise plans only.

Details on pricing can be found here: https://www.smartsheet.com/pricing 

(You can also chat with our Sales team if you have further questions on pricing.)