Multiple IF statements then function

JLsmartsheet ✭✭
edited 10/06/22 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!