User Profile
smodkins
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Percentage Complete for text fields with variable N/A value
Hello! I am hoping someone can help with the following: I have 9 columns in a sharepoint, each one representing a type of check. I want a column after that calculates the percentage of checks that are clear. Not all checks are applicable to check record so if their value is "N/A" I don't want them to be included in the calculation. For the purposes of the formula you can call them "Col1" to "Col9" The three possible choices in the column are: Pending Passed N/A So if all 9 checks are relevant they will begin as Pending. If 6 change to passed then the formula would return a value of 67% clear. If any of the columns are set to N/A then they should not be included. So if 1 column is set to N/A, 4 are set to pending, 4 are set to Passed then the formula should return 50% Thanks in advance1.4KViews0likes2Comments
Recent Blog Articles
No content to show