Help with a formula : need one for duration since received ?
Hello :) looking for a formula to give me the days since received from planner . only counting working days M-F. Thank you
Best Answer
-
I'm glad this worked for you.
The following formula checks the cell [Completed Date]@row for a blank, if it's blank it will preform the formula, if it's not blank then it will populate "Completed". Replace the word [Completed Date] with the name of your completed column.
=IF([Completed Date]@row="",NETWORKDAYS([DATE RECIVED FROM PLANNER]@row, (TODAY())),"Completed")
You can replace the word at the very end in quotes "Completed" with whatever you want it to say or make it blank with ""
Answers
-
Hello @BCALLEN
Let me know if this formula works for you:
=NETWORKDAYS([DATE RECIVED FROM PLANNER]@row, (TODAY()))
-
yes that works thank you SO SO MUCH!! is there a way for it to STOP counting when the COMPLETED DATE is entered ? @Mr. Chris
-
I'm glad this worked for you.
The following formula checks the cell [Completed Date]@row for a blank, if it's blank it will preform the formula, if it's not blank then it will populate "Completed". Replace the word [Completed Date] with the name of your completed column.
=IF([Completed Date]@row="",NETWORKDAYS([DATE RECIVED FROM PLANNER]@row, (TODAY())),"Completed")
You can replace the word at the very end in quotes "Completed" with whatever you want it to say or make it blank with ""
-
THATS PEWRFECT !! THANK YOU @MrChris
-
My pleasure! Thanks for the feedback.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
