Substitute Multiple Strings

[Denys_Saisse1]

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 :grinning:

[Kamille_Parks]

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.

[Denys_Saisse1]

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 :confused:

Here is a screenshot of the table + fields details

Thank you in anticipation

[Alexey_Gusev]

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.