Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Sep 09, 2020 10:00 AM
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:
Sep 09, 2020 10:28 AM
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:
Best of luck!
Sep 09, 2020 01:08 PM
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!