How identify where actual lag time is different from standard lag time?

Peter F

Need a way to identify tasks on my workplan where the actual lag time is different from the standard lag time. 

My workplan includes:

1.  Predecessor column (includes predecessor with +/- lag)

2. A separate text column "Standard Lag Time "

Whenever the lag time needs to be changed the predecessor column is updated.  The Standard Lag Time column is never changed as it serves as a reference.

How can I have Smartsheet format (e.g. highlight) predecessor cells whenever the lag time is different from the Standard Lag time?  

Mike Wilday

We implemented an Actual Start Date and Actual Finish Date column for documenting when we actually began and ended a particular task. Then you can implement netdays or networkdays formula to calculate the actual days, as use that number to compare against the planned start and finish. 

• https://help.smartsheet.com/function/netdays
• https://help.smartsheet.com/function/networkdays