# Need Help with my Nested IF statement formula

Options

I have spent at least 2 hours reading multiple Q & A's in this Community as well as watched multiple videos to no avail! I give up and need help!

I have a column of Service Years (Y1, Y2, Y3) and want to add statement in adjacent column dependent on the Service Year.

Y1 should be "2023-24" / Y2 should be "2022-23" and Y3 should be "2021-22". I have tried many different ways of writing the formula and still get #UNPARSABLE. Does it have something to do with the parenthesis? Spacing? Here are a few I have tried:

=IF([Billing / Service Year]@row = "Y1", "2023-24"), IF([Billing / Service Year]@row = "Y2", "2022-23"), IF([Billing / Service Year]@row = "Y3", "2021-22")

=IF([Billing / Service Year]@row = "Y1", "2023-24", IF([Billing / Service Year]@row = "Y2", "2022-23", IF([Billing / Service Year]@row = "Y3", "2021-22")

=IF((([Billing / Service Year]@row = "Y1", "2023-24", IF([Billing / Service Year]@row = "Y2", "2022-23", IF([Billing / Service Year]@row = "Y3", "2021-22")))

• ✭✭✭✭✭✭
Options

That second one looks like it should be working properly. Are you able to provide a screenshot of that one actually in a cell similar to the screenshot below?

• Options
• ✭✭✭✭✭✭
Options

That looks like the first one you posted. What about the second one?

• Options

Well, this is embarrassing - this reminds me of when I go to the auto repair shop with a noise or condition that doesn't happen when I get there! Now it is working. I swear it did not before. Thank you so much for your quick assistance! I am a new fan of this Community!!

• ✭✭✭✭✭✭
Options

No worries. Sometimes there can be a little bit of latent data on the back-end taking longer than it should to clear out that can cause an otherwise perfect formula to generate a (false) error.

Glad it is working for you now.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!