Calculating Networkdays within certain criteria

Options
BFuller
BFuller ✭✭✭
edited 11/16/22 in Formulas and Functions

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!



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!