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

Peter F
Peter F ✭✭
edited 12/09/19 in Formulas and Functions

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?  


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!