IF formula to calculate points


I'm trying to create a formula to calculate points and I can't seem to get it right. This is what I have:

=IF((Occurrence@row = "Tardy", 1), IF(Occurrence@row = "Late", 2), IF(Occurrence@row = "Half", 3), IF(Occurrence@row = "Full", 5),0)

Basically, if the Occurrence column has any other those, each is worth a specific point value. Otherwise, the value should be 0.

Someone save me from myself, please 😅


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!