IF formula to calculate points

Sam C

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 😅

Andrée Starå

@Sam C

Excellent! Yes, but the main issue was that you had too many parentheses and closed each section.

Easy to miss!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Sam C

I hope you're well and safe!

Try something like this.

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

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sam C

Yes! That worked! And it looks like I put a comma where a parenthesis should have been 🤦 Thanks again!

Andrée Starå

@Sam C

Excellent! Yes, but the main issue was that you had too many parentheses and closed each section.

Easy to miss!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!