Unparseable

Options

I am typing in this formula and getting an error message. Does anyone know why?


=IF([Actual Sub Date]@row > DATE(2020,5,1)),if([Actual Sub Date]@row < date(2020,7,31)),"Q1 FY21","NA"


Please help!

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Sandra Vulis Petrosyan

    Your IF statements are closed prematurely which doesn't allow for the logic statements to execute.

    Try this

    =IF([Actual Sub Date]@row > DATE(2020, 5, 1), IF([Actual Sub Date]@row < DATE(2020, 7, 31), "Q1 FY21", "NA"))

    As a rule of thumb, there will be at least the number of parentheses ending a formula as the number of IFs in the formula. Not always, but as a rule of thumb.

    cheers,

    Kelly

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Sandra Vulis Petrosyan

    Your IF statements are closed prematurely which doesn't allow for the logic statements to execute.

    Try this

    =IF([Actual Sub Date]@row > DATE(2020, 5, 1), IF([Actual Sub Date]@row < DATE(2020, 7, 31), "Q1 FY21", "NA"))

    As a rule of thumb, there will be at least the number of parentheses ending a formula as the number of IFs in the formula. Not always, but as a rule of thumb.

    cheers,

    Kelly

  • Sandra Vulis Petrosyan
    Options

    Thank you! Now I am trying to do it for entire FY but getting blanks


    =IF([Actual Sub Date (Month/Day/Yr)]@row > DATE(2020, 5, 1), IF([Actual Sub Date (Month/Day/Yr)]@row < DATE(2020, 7, 31), "Q1 FY21"), IF([Actual Sub Date (Month/Day/Yr)]@row > DATE(2020, 8, 1), IF([Actual Sub Date (Month/Day/Yr)]@row < DATE(2020, 10, 31), "Q2 FY21"), IF([Actual Sub Date (Month/Day/Yr)]@row > DATE(2020, 11, 1), IF([Actual Sub Date (Month/Day/Yr)]@row < DATE(2021, 1, 31), "Q3 FY21"), IF([Actual Sub Date (Month/Day/Yr)]@row > DATE(2021, 2, 1), IF([Actual Sub Date (Month/Day/Yr)]@row < DATE(2021, 4, 30), "Q4 FY21")))))

  • Sandra Vulis Petrosyan
    Options

    Actually, it works! Thank you again for your help.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!