Help with IF/THEN Network days formula when another field is marked Yes or No


Trying to calculate Network days between two date fields. If one of the dates is blank, then the calculation between the dates uses Today. The formula works great, but in some cases, I won't have dates populated for either field (another field named Comments with selection of Yes or No would be completed). So I want the formula result to remain blank and need to add in an IF/THEN type criteria to only run when the Comment Field = Yes (meaning there would be a dates needed in those fields). Any ideas?

=IF(ISBLANK([CMO Feedback Received Date]@row), NETWORKDAYS([Batch Record Review Complete (Date)]@row, TODAY()), NETWORKDAYS([Batch Record Review Complete (Date)]@row, [CMO Feedback Received Date]@row))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!