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

BCALLEN · 01/11/24

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

=Chris Palmer · 01/11/24

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 · 01/11/24

Hello @BCALLEN

Let me know if this formula works for you:

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

BCALLEN · 01/11/24

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 · 01/11/24

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 · 01/11/24

THATS PEWRFECT !! THANK YOU @MrChris

=Chris Palmer · 01/12/24

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

My pleasure! Thanks for the feedback.

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

Best Answer

Answers

Help Article Resources

Categories