I need to automate due dates rolling forward

I want to automate due dates. For example:

  • Column 1: Funding Date (I manually enter)
  • Column 2: PPP 8 week end date: Calculated field that is 8 weeks from “funding date”.
  • Column 3: Forgiveness Application Due date:  Calculated 90 days from “PPP 8 week end date”

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!