I need a formula that checks to see if all the assessments in a given area are compelted.

MJ215

I want a formula to check and see that all the assessments for Anti-Corruption are completed and send an alert based on that.

Mark Cronk

Create a checkbox column [Alert] with the column formula:

=IF(COUNTIF(risk: risk, risk@row)= COUNTIFS([high risk assessment progress]:[high risk assessment progress], "Complete", risk:risk, risk@row), 1, 0)

The [Alert] checkbox will check if all risk entries are complete. Set up automation to send an alert when [Alert] is checked.

Work?

Mark

MJ215

I tried to set this up as a simple true and false, but this didn't seem to work.

=IF(COUNTIF(Risk1:Risk90, Risk@row) = COUNTIF([Risk Assessment Progress]1:[Risk Assessment Progress]90, "Complete", Risk1:Risk90, Risk@row), true, false)

Mark Cronk

Hi,

The 2nd count needs to be COUNTIFS. Try:

=IF(COUNTIF(Risk1:Risk90, Risk@row) = COUNTIFS([Risk Assessment Progress]1:[Risk Assessment Progress]90, "Complete", Risk1:Risk90, Risk@row), true, false)

Work now?

Mark