One additional question-

There are two columns that I am try to have work together. The points total and the size. However one of the selections should just always make the size be â€śSmallâ€ť. i.e Desired behavior is "If Express = Yes then the points total should be 0 or the points total should work but the size should always be small.

If in the points total col I check this condition outside of the sum it just appends the value like a text string:

Points Total Formula:

SUM(IF({New Feature}=â€śYesâ€ť,300,0), MULTIPLY({Num Languages}, 10),MULTIPLY({Num Countries}, 10),MULTIPLY({Num ePRO}, 10),IF({Data Integration}=â€śYesâ€ť,10,0),IF({Wearable}=â€śYesâ€ť,10,0),IF({Provisioning}=â€śYesâ€ť,10,0))&IF({Express}=â€śYesâ€ť, â€ś0â€ť, â€śâ€ť)

For the above if the points total is 410 and Express is Yes then the display is 4100. I could just put this inside the sum and subtract 10,000 so the points are always in the small (but this seems like a hack)

Project Size Classification Formula

IF(AND({Points Total} >= 0,{Points Total} <= 100), â€śSmallâ€ť ,"") &IF(AND({Points Total} >= 101,{Points Total} <= 199), â€śMediumâ€ť ,"") &IF(AND({Points Total} >= 200,{Points Total} <= 299), â€śLargeâ€ť ,"") &IF(AND({Points Total} >= 300,{Points Total} <= 5000), â€śX-Largeâ€ť ,"")

Question. Is there the concept of IF condition is true do something else do nothing? It seems I have to provide IF({Some column} > 100, â€śBig Dealâ€ť, â€śSmall Dealâ€ť) both results. Like if I change the â€śSmall dealâ€ť to â€śâ€ť it inserts a blank. It doesnâ€™t see to have the concept of IF({Some column} > 100, â€śBig Dealâ€ť). ie do noting and continue.

I guess I could wrap the entire sum in an IF. IF({Express} = â€śYesâ€ť, â€ś0â€ť, â€śdo the big sum formula aboveâ€ť). Would that be the way?

It would be nice if there was the IF do something else do nothing

Thanks