Help with question for multiple approvers.

mrigau

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

mrigau

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

😀

mrigau

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

😀