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.
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.
Best Answers
-
Try something like this:
=IF(COUNTIFS(Status:Status, @cell = "In Progress", [Assigned To]:[Assigned To], @cell = [Assigned To]@row)>= 5, "No")
-
You've got some syntax issues and typos. Try putting the formula I provided in the Max Capacity column.
Answers
-
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.
-
Sorry for the lack of info. I added a screenshot of an example table. Thank you, @Mike TV
-
Try something like this:
=IF(COUNTIFS(Status:Status, @cell = "In Progress", [Assigned To]:[Assigned To], @cell = [Assigned To]@row)>= 5, "No")
-
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?
-
You've got some syntax issues and typos. Try putting the formula I provided in the Max Capacity column.
-
It worked really well. Thank you, @Paul Newcome
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!