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.

Screen Shot 2022-10-06 at 3.20.28 PM.png

Find more posts tagged with

Accepted answers

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.

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.