Help with a formula : need one for duration since received ?

BCALLEN

Hello :) looking for a formula to give me the days since received from planner . only counting working days M-F. Thank you

=Chris Palmer

https://community.smartsheet.com/discussion/comment/413096#Comment_413096

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 ""

=Chris Palmer

Hello @BCALLEN

Let me know if this formula works for you:

=NETWORKDAYS([DATE RECIVED FROM PLANNER]@row, (TODAY()))

BCALLEN

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

=Chris Palmer

https://community.smartsheet.com/discussion/comment/413096#Comment_413096

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 ""

BCALLEN

THATS PEWRFECT !! THANK YOU @MrChris

=Chris Palmer

https://community.smartsheet.com/discussion/comment/413129#Comment_413129

My pleasure! Thanks for the feedback.