Calculate Top 7 quarters

[Andrew_Seaman]

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?

[mceleavey]

Hi @Andrew_Seaman ,

Can you please attach the data and we'll build it for you.

M.

[Andrew_Seaman]

Here is the data.

[atcodedog05 · Accepted solution]

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 🙂

[mceleavey]

@Andrew_Seaman ,

In addition to @atcodedog05 's formula approach, I've also built this without using any formulae (other than yours):

M.