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!