Formula For conditions

I have a column in a sheet called Notes, in which people enter how many notes they have done for the week. I need to assign points for what they did, and here are the details:

1 point for every note, regardless of how many.

In addition to that, the following:

If notes are less than 9 it should be -1 point or

If notes are greater than 12, they get +2 points

So if they input 9 notes, the math should be 9 - 1. If they did 10 or 11 notes, they get the 10 or 11 points. If they did 12 or more, it should be 12 + 2.

How do I write that formula to get a total?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!