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

  • Mr. Chris
    Mr. Chris ✭✭✭✭✭
    edited 01/11/24 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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!