Can I make a cells value 0.6 instead of 1 when a cell in a specific column is checked?
Good Afternoon,
I am trying to create a formula that countifs the cell is checked but instead of counting it as 1 I would like to count it as 0.6 of a point. So to be more exact with the task at hand, Anytime one of the techs check a box in "Missing Parts" and "Failed Parts" Column i would like it to count 0.6. Anytime a cell is checked in those columns those points are then added back to "Gate 1 - Score" and "Gate 2 Check - Score". Not sure what the formula would look like to make what im asking happen. This is where i could use the help. Thank you in advance for any help given
Thanks, ECD Automotive Design
Answers
-
Gate 1 score
=countif([missing parts]:[missing parts],1)*.6+countif([failed parts]:[failed parts],1)*.6
I'm not sure I understand what you want for the gate 2 check score
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!