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

=if(Notes@row>=12, Notes@row +2, if(Notes@row <= 9, Notes@row 1, if(Notes@row=0, 0, Notes@row)))
This accounts for zeros.
Answers

=if(Notes@row>=12, Notes@row +2, if(Notes@row <= 9, Notes@row 1, Notes@row))

=if(Notes@row>=12, Notes@row +2, if(Notes@row <= 9, Notes@row 1, if(Notes@row=0, 0, Notes@row)))
This accounts for zeros.

That worked perfectly @Michael Culley. Thank you so much!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 379 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 304 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!