Help with question for multiple approvers.

Options
mrigau
mrigau
edited 06/21/22 in Formulas and Functions

Hi forum, looking for your advice on a formula. I have a workflow that requires approval of Yes or No from multiple locations. Some changes apply to a few locations, and some changes apply to all locations. I have a sheet that describes the change and multiple columns for each location to capture their Yes or No approval on the same row.

I will like to create a Symbol field of red, amber, and green to summarize the approvals. Green = if all the sites that need to approve are approved with Yes, and yellow if any of the sites has still not been approved and skip the ones that do not apply since they are not impacted by the change. I have another drop-down multiselect field that lists the sites impacted.

Any guidance on this is really appreciated. Thanks

Best Answer

  • mrigau
    mrigau
    Answer ✓
    Options

    I think I got it. I compared the count of sites that were approved and if they match the entries of the dropdown of the sites impacted is a GO.

    =IF(COUNTIF(SITE1@row:SITE9@row, "Yes") = COUNTM([Site Impacted]@row), "Yes", "Hold")

    This seems to work.

    Thanks

    😀

Answers

  • mrigau
    mrigau
    Answer ✓
    Options

    I think I got it. I compared the count of sites that were approved and if they match the entries of the dropdown of the sites impacted is a GO.

    =IF(COUNTIF(SITE1@row:SITE9@row, "Yes") = COUNTM([Site Impacted]@row), "Yes", "Hold")

    This seems to work.

    Thanks

    😀

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!