Skip to main content

Hi everyone,


Hope you’re going well.


I’m struggling with a formula.


I have 3 colomns:

#1 - All Time Slots Rollup

A, B, C, D


#2 - All Booked Time Slots Rollup

A, C


#3 - Formula Colomn that substiture Colomn #1 data with Colomn #2 strings.

B, D


I found the formula to make substitute one string.


SUBSTITUTE(colomn1&"",colomn2&"","")

Unfortunaly this formula doesn’t work when there is more than 1 string in colomn2.


What formula should i use ?


Thank you in anticipation 😀

If Columns 1 and 2 are rollups, are they pulling from the same Link Record connection?


Your third column might be able to be a Rollup, not Formula, with a condition applied to only show time slots that aren’t “booked”. Screenshots of your set up would be useful.

If Columns 1 and 2 are rollups, are they pulling from the same Link Record connection?


Your third column might be able to be a Rollup, not Formula, with a condition applied to only show time slots that aren’t “booked”. Screenshots of your set up would be useful.


Hey Kamille,


Thank you for your quick reply.


Unfortunaly, rollups on Colomn #1 and Colomn #2 are links for 2 differents table. Then I can’t do a filtered Rollup 😕


Here is a screenshot of the table + fields details


Thank you in anticipation

Hey Kamille,


Thank you for your quick reply.


Unfortunaly, rollups on Colomn #1 and Colomn #2 are links for 2 differents table. Then I can’t do a filtered Rollup 😕


Here is a screenshot of the table + fields details


Thank you in anticipation


Hi,


You can do 2 subsequent operations for each value, but if there might be 3 or 4 values in lookup, it’s not a solution.


But I think you can do filtering. Add ‘lookup of lookup’ into the table where rollup data located. Create formula smth like FIND({field_where_rollup_data_located},{lookup}&‘’)>0. Filter rollup by condition using formula output.

Reply


Terms & Conditions