Why would this formula return an error message?

Carey Drayton

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())))

Paul Newcome

It looks like there may be a few issues. Are you able to provide some screenshots for reference and more detail as to what you are trying to accomplish?

Carey Drayton

Screen Shot 2022-03-07 at 10.01.05 AM.png

Screen Shot 2022-03-07 at 10.00.40 AM.png

I am tracking repairs of CCTV. My supervisor wants to have the Workdays a ticket is open until it is closed. When I originally created the sheet I did not have any resolved tickets. Now that I have resolved tickets and open tickets I would like to have a single formula to determine the Correct Workdays a ticket is open if resolved and then when it is still open.

Thank you for your assistance.

Paul Newcome

Try this:

=NETWORKDAYS([Issued Date]@row, IF([Ticket Status]@row = "Resolved", [Resolved Date]@row, TODAY()))