Entering a number when a word is chosen

Question

I have two columns (Incident or Accident) and (Points Received).

When Incident is picked from the dropdown I need "1" entered into Points Received.

When accident is picked from the dropdown I need "2" entered into Points Received.

This is what I have but it is not working:

=IF([Incident or Accident]@row = "Incident", "1", IF([Incident or Accident]@row = "Accident", "2"))

Please let me know what I am doing wrong or what I am missing. Thanks!

Andrée Starå · Answer

Excellent!

Happy to help!

✅ Remember! Did my comment/answer help? Please support with 💡 ⬆️ ❤️ ✅ so others find it. Thank you! 🙏

benetta.francique · Answer

I figured it out and yes the formula worked. Thanks!

Andrée Starå · Answer

https://community.smartsheet.com/discussion/148151/entering-a-number-when-a-word-is-chosen

Hi,

I hope you're well and safe!

Try this.

=IF([Incident or Accident]@row = "Incident", 1, IF([Incident or Accident]@row = "Accident", 2)

Did that work/help?

I hope that helps!

Have a fantastic day!

Andrée Starå | Smartsheet Expert Consultant and Partner / CEO @ WORK BOLD

✅ Did my comment/answer help? Please support with 💡 ⬆️ ❤️ ✅ so others find it. Thank you! 🙏