Count # of networkdays if a condition is not met

Paula Cosentino
Paula Cosentino ✭✭✭✭✭
edited 05/04/24 in Formulas and Functions


I want a formula to count the number of workdays between when an item was assigned only if a condition is not met.

=IF(Request Status - Contracting]@row <> "Contract work Complete", [Date Assigned to CM]@row, TODAY())

I want the # of days counted since an item was assigned to a manager only if the manager has not marked the line "Contract work Complete". To make things just a bit harder, I don't want the column "Request Status - Contracting" to equal "Contract work complete" or "Contract work executed"

Thank you for any help! :-)


Best Answer

  • BullandKhmer
    BullandKhmer ✭✭✭✭✭
    Answer ✓

    =IF(OR(Request Status - Contracting]@row <> "Contract work Complete",[Request Status - Contracting]@row <> "Contract work Executed"), NETWORKDAYS([Date Assigned to CM]@row, TODAY()))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!