How would I add a MAX function to COUNTIFS formula?

ClanMcDe

ISSUE 1:

I have a formula I'm using to update a radio button called "Paused" to identify items in another sheet that are paused. I need to make sure it looks at the most recent occurrence of the item in the list using the last run date.

How would I add a MAX function to this formula using the last run date.

=COUNTIFS({Analyst Request Tracker with Form Range 2}, [Task Name]@row, {Periscope Request Tracker Range 1}, <>1)

ISSUE 2:

how do I keep from having "#BOOLEAN EXPECTED" error when the radio button is not checked?

Paul Newcome

Are you able to provide screenshots for context?