System Column - Last Modified

lisarae723

Hi everyone!

Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" 

Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the sheet updates as if it were modified. 

Any feedback would be greatly appreciated!

Thank you!

Lisa

Paul Newcome

Are you using the TODAY() function in a formula in all of those rows?

lisarae723

Ahh... yes, I am. That's the culprit:) I knew there was something within the sheet causing chaos!

Any thoughts on a work around?                                                                                                              

Paul Newcome

Here is my suggestion...

 

Approver column is Contact type.

Add Date type column.

 

Change workflow from Approval to Update Request and send the contact and date columns. Approver enters their name and the approval date.

 

Set workflow to run based on the submission date column being 10 days in the past with a condition of the approval date column being blank.

lisarae723

Thank you for the suggestion!

Paul Newcome

Happy to help! 

 

Let us know how it works out for you.

Andrée Starå

Hi Lisa,

Another option could be the third-party service, Zapier. It's an excellent option for this scenario. Is that an option for you?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD