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?
Hi @Andrew_Seaman
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 🙂
Hi @Andrew_Seaman ,
Can you please attach the data and we'll build it for you.
M.
Here is the data.
