How to lock in a date "fixed date" in a sheet
MS Project has a way to lock in a date as a fixed date. Typically on a plan, an immoveable date. What I'm trying to do is have the system 'flag' any issues where, any slippage on the earlier task will start to risk that 'immoveable date' from being violated. I want the Automation rule to email me when a preceding task ends up risking that date not being met.... how do I do this (in Smartsheet, I know how to do it in MSFT Project).
Answers
-
You can add a date field and set a date in it, either manually or by formula, or through automation based on another cell being changed...
Create a helper column "Days Remaining" or something like in there calculating the days between your projected completion date and that immovable date (you can use NETDAYS, NETWORKDAY, or NETWORKDAYS to do this.)
Functions List | Smartsheet Learning Center
Then you can setup an automation rule, something like this:
Trigger: When a row changes, when Days Remaining = 5
Action: Send and Alert to specified recipients, contacts in a cell, or users shared to sheet.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!