I’m using an integration via Integromat to pull in some records for a report function.
I have lots of records in my base for different names (Name) and have formatted a field called Period which is the date created in the format “YYYY/MM”.
So I may have:
Dave / 2020/11 / Some Data
Dave / 2020/12 / Some Data
I need to return all records for Dave in a given period.
I can use FIND(“Dave”, Name) to return all records for Dave which works great.
What I really want is WHERE period = “2020/12”
How can I create a formula to search the base by Name and Period?