Trying to create a formula that determines the current season
I've got a formula that generates the current quarter and one that calculates the current year. Now I'm trying to write an IF statement that creates a value that says S23 by reading if its Q1 or Q2 and then adding the 23 from the current year (2023). This is my current formula, can anyone explain why it's not working or what I need to change?
=IF(OR([Current Quarter]="Q1",[Current Quarter]="Q2"),"S"+([Current Year]-2000),"F"+([Current Year]-2000))
I haven't used the OR function much so wonder if perhaps that's what's throwing the error.
Best Answer
-
Figured it out, I was just missing @row on all my column values. Here's the working formula if anyone needs.
=IF(OR([Current Quarter]@row = "Q1", [Current Quarter]@row = "Q2"), "S" + RIGHT([Current Year]@row, 2), "F" + RIGHT([Current Year]@row, 2))
Answers
-
Figured it out, I was just missing @row on all my column values. Here's the working formula if anyone needs.
=IF(OR([Current Quarter]@row = "Q1", [Current Quarter]@row = "Q2"), "S" + RIGHT([Current Year]@row, 2), "F" + RIGHT([Current Year]@row, 2))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!