Why would this formula return an error message?

I am using the formula to count networkdays on resolved tickets and networkdays on open tickets. Trying use the if formula, but error is returned. Any suggestions? Thank you,

=IF({Sheet - CCTV Issue Tracking with Form Range 25} = "Resolved", (NETWORKDAYS ({Sheet - CCTV Issue Tracking with Form Range 26}, {Sheet - CCTV Issue Tracking with Form Range 27})), (Networkdays ({Sheet - CCTV Issue Tracking with Form Range 26}, Today())))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!