Multiple Nested If Statements with Numbers

I'm trying to build a scoring system based on the number of times a new submission came in for different sites at my company. I have a form set up to feed into a sheet then have a background sheet with a countifs formula to get the number submitted each quarter. From there, I need to change this raw number into a score based on the number of submissions each site has but I keep getting "Unparseable" as a result. Is there something wrong with my formula below?

0 Submissions, 0 points

1 Submission, 3 points

2-4 submissions, 5 points

5 submissions, 10 points


=if([BP Approved]1 = 0, 0(if([BP Approved]1 = 1, 3(if([BP Approved]1 = 5, 10, 5)))))

Tags:

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    edited 04/30/21 Answer ✓

    Good evening,

    Try:

    =if([BP Approved]@row= 0, 0, if([BP Approved]@row = 1, 3, if([BP Approved]@row = 5, 10, 5)))

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    edited 04/30/21 Answer ✓

    Good evening,

    Try:

    =if([BP Approved]@row= 0, 0, if([BP Approved]@row = 1, 3, if([BP Approved]@row = 5, 10, 5)))

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!