Returning value based on date in another column


Looking for a solution / formula type on the following:

  • I want the Actual Phase Number column to give a number between 1 and 8.
  • The number it will give is calculated by first looking at the Actual DOC column. The date in row 1 showing 12/13/22 will look at Scheduled DOC and find the most recent date before. In this case, the most recent date before 12/13/22 is 12/02/22.
  • The Phase Number column for 12/02/22 shows '7'
  • I therefore want row 1 of the Actual Phase Number row to return '7'


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!