Sign in to join the conversation:
Hi,
Please can someone help with a formula to find if a row is parent and at the same time has a text that starts with "abcde".
=IF(AND(LEFT(PARENT(), 5) = "abcde", COUNT(CHILDREN()) > 0), "Y", "N")
Change Y or N to what you need, depending on whether the formula meets the criteria.
Note that this will only check for children in the same column
Thanks for this. Is there a way to find if the PARENT OR the GRANDPARENT has the word "abcde"?
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,…
I need to extract information from 2 different sheets based on the name of the member organisation and the join year (i.e. DD/MM/YYYY). The 2 sheets have the same column titles, but one is for 2024 and another one for 2025. Where organisation joined earlier than 2025, then it needs to fetch the data from the 2024 sheet,…
How do I set up the automation to move a row once the created date reaches 5 days?
