Formula that would bring in data for the past three years

[Richie059]

Hey guys, So I'm trying to allow the user to select a year which would then select the data relevant to that year and the two prior years. However, I'm struggling a great deal. I have two columns I can work from for this. the "project Code" or the "Datetimeout" variables. Thanks everyone!

[atcodedog05 · Accepted solution]

Hi @Richie059 

Use filter formula like this for 3 yrs

Hope this helps : )

[saisaranv]

have you tried to extract the "Year" separately to New Column and you can filter condition with "Year - 3" (Range) like that.  

[atcodedog05]

Happy to help : ) @Richie059 

Cheers and have a nice day!