Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Get results for a matching period

Topic Labels: Formulas
1128 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Matthieu_B
4 - Data Explorer
4 - Data Explorer

Hello all!

I wouldlike to know if it’s possible to have in the column “test” all the items which are in the same period. For example in the first row of the colum “test” the result would be “FRT54522” because “FRT54522” has a period in common with “FRT5678C”.

Many thanks for your help :slightly_smiling_face:

example airtable 5

2 Replies 2
Zollie
10 - Mercury
10 - Mercury

Hey Matthieu! Airtable formulas only have access to one row of data at a time. So a formula executing in one row has access to any column values it needs, but not any other rows. The exception is the functionality that linked records/lookups afford, but I don’t think that helps in this case.

The alternatives you’re left with are probably:

  • filtering, sorting, or grouping your list by date ranges
  • write a script to populate TEST whenever you click a button
  • rig up a third party integration that automatically scours for updates to the base, and updates the TEST column as necessary

Best of luck!

Matthieu_B
4 - Data Explorer
4 - Data Explorer

Many thanks for your answer.
Doesn’t look easy for me :frowning:
Do you know where I can find somebody who can help me on this point?
Many thanks again for your answer!