How do I create a SUM based off of specific criteria?
I created a smartsheet to track an assistance program. I created a column with color-coded dots (RYG Balls) to represent the status of each application. These dots are changed manually as the application status changes. Red dot (declined), Yellow (Pending), Green (Accepted), and Blue (Completed). A different column has the amount of assistance we are providing for each application.
I wanted to create a sum to represent all of the assistance (in dollars $) that have been allocated for the applications coded as blue and green - is this possible?
It would be great if this could update on its own as we receive applications and manually choose their status because at this point I have to create a filter and manually change the total each time and it's becoming cumbersome.
Help Article Resources
Check out the Formula Handbook template!