Automatically alert when project goes beyond an install date

DavidHB

Hi,

We have multiple (50+) projects and once the project commences an install date with the customer is fixed.

I have set this up in smartsheet, to have the install with no prior dependancies. What I wont to do is set up an alert when the project build is after the agreed install date.

 

Any ideas on how I can do this?

 

Thanks for your help,

 

David

Andrée Starå

Hi David,

We'd use a so-called helper column to make this work. Something like a checkbox with a formula that checks the dates and checks the box and triggers an alert.

Would that work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

DavidHB

Hi Andree,

 

Thanks for your advice - any help on setting this up would be a massive help.

 

Thanks

 

David