Count days based on delay reason

Joseph Aloysias
Joseph Aloysias ✭✭✭✭✭
edited 11/26/22 in Formulas and Functions


I'm trying to calculate "delay in days" based on "delay reason" and add a condition when the delay reason is "scope" it shouldn't calculate as its delay(as per screenshot is 5 days (subtract)) , can anyone help me with the formula?


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Josephcopernicus

    It would be helpful to know more information about your specific sheet and set-up before we can help create a formula.

    Where are the "days" coming from? What are we comparing, to get the number?

    For example, do you have an "Due Date" column with a date in it, or a "Finish" date column, and are we comparing that to if the status is "Complete" and today's date? Or do you have another way of tracking with a row is due?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!