Calculating Networkdays within certain criteria

BFuller

Okay, Smartsheet Community! I need you! I have been tasked to create a process where we track content creators drafts and the number of days between. Below is a screenshot of part of my set up. I need to know the number of networkdays between PCD Draft 1 Start Date and SME Draft 1 Review Start Date when PCD Status Draft 1 is Sent to SME. Then, I need to know the number of networkdays between SME Draft 1 Review End Date and PCD Draft 2 End date when PCD Status Draft 2 is Sent to SME and so on. Thank you in advance!

Andrée Starå

Hi @BFuller

I hope you're well and safe!

Try something like this. (and continue the pattern)

=IFERROR(IF([PCD Status Draft 1]@row = "Sent to SME", NETWORKDAYS([PCD Draft 1 Start Date]@row, [SME Draft 1 Review Start Date]@row)), "")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

BFuller

It worked great! Thank you SOOOO much!

BFuller

Andrée Starå

@BFuller

Excellent!

You're more than welcome!