How to get the difference in dates, but not if the box is checked?

tchav
tchav ✭✭✭✭
edited 03/08/24 in Formulas and Functions

Hello,


I am trying to get the number of days between two dates but I dont want to include if the column with the checkbox is checked. How do I do this?



Tags:

Answers

  • SmartWay360
    SmartWay360 ✭✭✭✭

    Hi,

    You can use formula NETDAYS to calculate the difference. Or if you want to exclude weekends, you can use formula NETWORKDAYS.

    The function could be this:

    IF([W Status]@row=0, NETDAYS ([Analysis Date]@row, [Date Received]@row), "Completed")

    Hope this works for you :)

    Best,

    Beata

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!