Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
New to Formulas - Need help with Text Answers
I have tried to create a formula using three options being
1. Does not meet Insurance Standards,
2. Meet Insurance Standards
3. Exceeds Insurance Standards
for a particular series of questions.
If you choose "Does not Meet Insurance Standards" then then next column Score will also populate 1 and the cell will highlight yellow. If you enter "Meets Insurance Standards" then the Score will autopopulate 2 and the cell will highlight green. If you enter "Exceeds Insurance Standards" the Score cell will auto populate 3 and the cell will highlight darker green.
Please help someone