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

• ✭✭✭✭✭

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

• ✭✭✭✭✭

Hello @BCALLEN

Let me know if this formula works for you:

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

• ✭✭
edited 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

• ✭✭✭✭✭

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!