I am trying to create a formula in Smartsheet, which I am able to make work in Excel. However, the formula isn't working in Smartsheet. Does anyone have a solution?
What I want to do is calculate the next due date based on the current status and the date the status was updated.
=IF([Program Status]@row = “Apprenticeship Program - Phase 1”, SUM([Last Status Change]@row+120),0)
Dr. Scott Tierno, D.A., PMP
Director of the Academic Leadership Academy
Help Article Resources
Check out the Formula Handbook template!