Variance formula between Baseline End Date vs Today vs Actual End Date

Options

Hi Community,

How to get only 1 formula for combining :

If Today >= Baseline End Day = positive days behind schedule, if not "0"

If Task "Completed", showing the variance between Actual and Baseline End date

Thank you

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    Options

    @Ludivine

    Could we get a screenshot of what it is your working with. Be sure to clean it of any sensitive information.

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

  • Ludivine
    Options

    How to get only 1 formula in column 'Behind schedule/Potential impact on delivery' showing the variance between Baseline End date vs Actual end date only if Actual date = >Today , if not showing "0'

    And in the meantime how to STOP the countdown as soon as the status of the task is triggered as "Completed', but still showing the days behind schedule, if any.

    Thank you

  • Ludivine
    Options

    Hi @Mark.poole

    Is there any formula that can fit our need in this case?

    Thank you

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    Options

    @Paul Newcome

    Any Input on this one?

    I haven't gotten this deep into Smartsheet yet so i am not sure how to answer.

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!