I am trying to fix a formula for hours, but I can't find the error. For some reason, the last argument in an OR Formula is ignored.The base has 2 tables (Table 1 and Table 2)Table 1 has one record with the following values:Field 1 (single line text) ...
I have been reading for hours through the help forum and documentation, but ARRAYSLICE doesn't want to work for me.I want to achieve the following: Show me the first value of an array. My formula is: ARRAYSLICE(verticals_from_contact, 1, 1) but it do...
I solved it. The REGEX lookup formula added a "space" before the lookup value, and therefore, the value in {field_3_table_1} was not equal to the value in {array_table_2}. Thanks to everyone who looked into this.Learning: The main formula was correct...
Update:Adding to the confusion, I ran several tests and checked each condition. The formula works perfectly except when:The correct value (e.g. C) is in{field_3_table_1} (single line text)and in the array {array_table_2} at the first position. If the...
We do the lookup of each table through Make.com. Yes, the whole formula is more extensive, but I thought it was too much to ask anyone here to read through the whole thing. Please find below the whole formula: AND(
FIND('{{58.stage}}',{stage}),
...
I found the solution, and I hope it helps everyone who faces the same issue.We need to extract the values with REGEX. The formulas to extract the first, second, and last values are as follows:Extract first value: REGEX_EXTRACT(verticals_from_contact,...
For anyone who will read this in the future, I just made the following learning:According to the Airtable documentation "Array functions can only be used in rollup fields or when the input field is a lookup field."This is misleading and not 100% corr...
