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

  • =Chris Palmer
    =Chris Palmer ✭✭✭✭✭
    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 ""

    https://www.linkedin.com/in/zchrispalmer/

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!