Multiple IF statements then function

JLsmartsheet

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.

Thank you.

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.

Paul Newcome

Try something like this:

=IF(COUNTIFS(Status:Status, @cell = "In Progress", [Assigned To]:[Assigned To], @cell = [Assigned To]@row)>= 5, "No")

Paul Newcome

You've got some syntax issues and typos. Try putting the formula I provided in the Max Capacity column.

Mike TV

@JLsmartsheet

This should be easy to set up. Going to need more information though. Can you show an example of "progress number reaches 5 per resource"? Also, you are going to need to define other variables and what symbols you want displayed unless the warning sign column is just to display a warning sign and isn't going to be used to display anything else and will be blank otherwise.

JLsmartsheet

Sorry for the lack of info. I added a screenshot of an example table. Thank you, @Mike TV

Paul Newcome

Try something like this:

=IF(COUNTIFS(Status:Status, @cell = "In Progress", [Assigned To]:[Assigned To], @cell = [Assigned To]@row)>= 5, "No")

JLsmartsheet

Thank you @Paul Newcome,

I tried

=IF(COUNTIFS(Status:Status, @cell = "In Progress", [Assigned to]:[Assigned to], @cell = A,[Assigned to]@row) >= 5, [Max Capacity:Max Capacity] ="No")

and got UNPARSEABLE. What have I missed?

Paul Newcome

You've got some syntax issues and typos. Try putting the formula I provided in the Max Capacity column.

JLsmartsheet

It worked really well. Thank you, @Paul Newcome

Paul Newcome

Happy to help. 👍️