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