Automatically alert when project goes beyond an install date

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

1 11 19.PNG

Find more posts tagged with

Manufacturing

Project Management

Email Notifications

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Forms
On the App - "In Smartsheet forms, is there a way to capture or upload an image directly into a specific column cell (per row) without using the Attachments field? I need each section of the form to have its own dedicated image, not just general attachments for the row."
Smartsheet Mobilizer Kit2/Best Practices
Hi - I am launching Smartsheet sessions at my organization for the next 3 months. The SS Mobilizer Kit2 Workspace I saved a few years back, the files are not loading. Is there a new resource kit? Also, I am writing up some best practices for our users: Examples: Names, separate first and last name into two columns. Email…
Workspace is still there but all folders are empty
Hey, I had a Project in January where I created multiple sheets, dashboards etc. Now I want to prepare the same project again but all folders are empty. Not a single sheet is left. How is that possible ? I upgraded to a paid account during that time and Iwanted to do that again but smartsheet do not delete everything if…