Unparseable

Sandra Vulis Petrosyan

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!

Kelly Moore

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

Kelly Moore

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

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

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