Multiple IF statements then function

JLsmartsheet
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.

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


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!