Formula to calculate 2 dates within 5days

edited 10/06/22 in Formulas and Functions


I would like to write a formula that will calculate 2 dates based on this criteria.

Titled: Percentage of Requests "In Progress" within 5days

  • I'm creating a control sheet that includes percentages only
  • On a separate (our main sheet where things are tracked) sheet I have a "created date column" and a "date put in progress column".
  • On my control sheet i would like it to calculate the percentage of requests put in progress within 5days.

Please help! I've tried so many things.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!