Formula @row = a score
I have 2 sheets, 1 sheet is the inventory smartsheet the other is the scoring worksheet based on the inventory items. I am trying to create a formula that will pull in the score from the scoring worksheet to the inventory smartsheet.
For example on the inventory worksheet-Column Name is "Access control Type". When someone chooses "unknown" in this column the score "25" (which comes from the scoring sheet) will populate in the "Access control score" on the Inventory smartsheet .
There are multiple access control types with different scoring associated.
How do I create the formula to populate the scoring based on the Access control type chosen?
Help Article Resources
Check out the Formula Handbook template!