Unparseable
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
-
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
-
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
-
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")))))
-
Actually, it works! Thank you again for your help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!