Sign in to join the conversation:
I created several fields in the summary sheet. Is there a way to use the filter option in the grid to update the summary fields? I created a date between filter and want it to apply to the summary sheet. Currently it does not work together.
Unfortunately you cannot filter the Summary fields. If your summary fields are populated via formula, there may be a workaround, but it could potentially get a little complex. Feel free to Submit a Product Enhancement Request when you have a chance.
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?
