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

Options

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


Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • MJ215
    MJ215 ✭✭
    Options

    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
    Mark Cronk ✭✭✭✭✭✭
    Options

    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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!