Processing Time (Days)

Options
Marilen.Navarro103391
Marilen.Navarro103391 ✭✭✭✭✭


Hello-

Can you help me with my formula? Processing time is "0" should be 1 day.

Thanks.

=IFERROR(IF(NOT(ISBLANK([Date Recorded Quote]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded Quote]@row), IF(NOT(ISBLANK([Date Recorded CE Leads]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded CE Leads]@row), IF(NOT(ISBLANK([Date Recorded Pipeline]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded Pipeline]@row), IF(NOT(ISBLANK([Date Recorded for PO Submitted]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded for PO Submitted]@row), IF(NOT(ISBLANK([Date Recorded for Others]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded for Others]@row)))))), "")



Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!