Hello! How do I create a rollup column with a filter? For example, I need to fetch data from another table, but specifically those that have the column Type: Entry or Exit. I need to filter this in the Rollup, but there are no filters or conditions. How could I do this?
Hi @Hustlei, you can use the Formula field to accomplish this:
Formula (filters by type): filter(lookup('Campaigns', 'Type'), or(totext(lookup('Campaigns', 'Type')) = 'Entry', totext(lookup('Campaigns', 'Type')) = 'Exit'))
Formula 1 (filters + counts by type): count(filter(lookup('Campaigns', 'Type'), or(totext(lookup('Campaigns', 'Type')) = 'Entry', totext(lookup('Campaigns', 'Type')) = 'Exit')))
Will it work for you?