Issues with IF formula

Question

I have two formulas which work well independently, but when I combine them they don't.

formula 1:

=IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row )))

formula 2:

=IF(YEAR([Joined date]@row ) < 2025, JOIN(COLLECT({Membership Survey 2024 - Experience}, {Membership Prioritisation Survey 2024 -Org}, [Organisation name]@row )))

What I'd like to have is a formula that combines the two, and fetches different information based on the joined year. I've built the following combined formula, but it only returns values where join year is <2025:

=IF(YEAR([Joined date]@row ) < 2025, JOIN(COLLECT({Membership Survey 2024 - Experience}, {Membership Prioritisation Survey 2024 -Org}, [Organisation name]@row ), IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row )))))

amarkumar · Accepted Answer

@Marta Pont

=IF(YEAR([Joined date]@row ) < 2025, JOIN(COLLECT({Membership Survey 2024 - Experience}, {Membership Prioritisation Survey 2024 - Org}, [Organization name]@row ), ", "),
 IF(YEAR([Joined date]@row ) = 2025,

JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritization Survey 2025 - Org}, [Organization name]@row ), ", "),
""
)
)

Paul Newcome · Accepted Answer

It looks like you just have a misplaced parenthesis is all.

=IF(YEAR([Joined date]@row) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row)), IF(YEAR([Joined date]@row) < 2025, JOIN(COLLECT({Membership Survey 2024 - Experience}, {Membership Prioritisation Survey 2024 -Org}, [Organisation name]@row))))