I have a table like this:
I used this formula to calculate the Current Quarter:
IF DateTimeToday() >= [Start] AND DateTimeToday() <= [End] THEN "Y" ELSE "" ENDIF
How can I get a column for top 7 Quarters that looks like this?
Solved! Go to Solution.
Here is how you can do it.
Workflow:
1. Using formula tool i am doing same calculation as yours for current_quarter
2. Using Mult-row formula tool by setting Num Rows as 6 i will be able to look into 6 rows below(+6) and above (-6). If any of the below rows (current to +6) [Current_Quarter]="Y" then set that rows [Top_7_Quarter]="Yes"
hope this helps 🙂
In addition to @atcodedog05 's formula approach, I've also built this without using any formulae (other than yours):
M.