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
-
I had to update it to NETWORKDAYS but then it worked. Thank you Ryan!
=IF(Status@row <> "Completed", NETWORKDAYS([Created Date]@row, TODAY()), "")
Answers
-
I don't think the Created Date system field really is a date field. Or a compatible date anyway.
You might consider running a date capture automation to fill in the Created Date and set the column type to date. It should work as expected.
-
@Samantha Gordon You were so close! try this...
=IF(Status@row <> "Completed", NETDAYS([Created Date]@row, TODAY()), "")
-
I had to update it to NETWORKDAYS but then it worked. Thank you Ryan!
=IF(Status@row <> "Completed", NETWORKDAYS([Created Date]@row, TODAY()), "")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!