If criteria is xxx, duration is zero

Nancy Skoulphong
Nancy Skoulphong ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Dear Smartsheet community,

I have a sheet for staff to report time off. 

I have this formula to calculate the net working day(s) between begin date and end date.

=NETWORKDAY([Begin Date]@row, [End Date]@row)

However there will be occasion when staff will not be taken time off. Therefore, I want to add where column Absence Name is No Leave Taken, then the result is zero.

Thank you!

 

Capture.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!