Behind/Ahead of Schedule by "x" days

Hi All,

I'd like to add a column that reflects how many days my project plan is ahead/behind schedule. I asked this question last year, but couldn't find it anywhere.

I have a Planned Finish and a Finish Date.

I'd like the row to display the following for each:

  1. If no variance, display "On Time"
  2. If late, display " X days Late"
  3. If early, display "X days Ahead".


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!