Multiple IF statements then function
Hi, I'm trying to see if what I want is possible. I'm using it for a simple resource capacity purpose.
I have columns for Assigned to (Different resource names), Status (In progress, on hold, complete), and Max capacity (drop-down list of warning signs).
This is what I want: When In progress number reaches 5 per resource, I want to have the max capacity to give out a warning sign.
I'm not sure if it's possible to set a number (e.g 5) as criteria for each resource and put the IF function.
Here are additional info. When the number of "Status" of "A" reaches to 5 "In progress"(s), I want the "Max Capacity" to give out "No" in the drop down symbol list.
Help Article Resources
Check out the Formula Handbook template!