I need a formula that checks to see if all the assessments in a given area are compelted.
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
-
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.
-
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)
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!