Business days since line created


I need to calculate workdays since date created if a line is NOT "completed". So if a line is still not completed, I want to know the aging date since line was created.

I have a formula to calculate ho many days have passed since a line was created if not completed, but I am lost trying to only pull workdays from the created date until today.

=IF(Status@row <> "Completed", TODAY() - [Created Date]@row, "")

I am receiving an error with the below formulas:

=IF([Status]<> "Completed", NETWORKDAY(TODAY() - [Created Date]))

=IF(Status@row <> "Completed", NETDAYS((today) - [Created Date]@row, ""))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!