The most vicious question about formula column! (must see)

FAQs
#1

Hi there!
Following is the most intriguing question of December!

I need a help with creating a formula for "Formula " column. The idea is it should show the occurrence of textual string. For example, if in “load#” column I have two identical textual or numerical values, formula cell in the same row should say “exists”.
Please, help me!

Thanks to all in advance!

#2

Hi @FrankZiyar - You mean that the formula column should alert you if any two or more rows on the board have a duplicate value for the text string? I’m pretty sure you can’t do this with standard Formula columns, but you could do it with Integromat or Zapier.

1 Like
#3

Hello @PolishedGeek !
Yes, the formula should alert users if there are more than two identical values in the same column. Thank you for your advice, I will try to use Integromat.

#4

Hello again @PolishedGeek! :joy:
I am new to integromat and can you advice me where I can get assistance with this app?
Thank you in advance!

#5

Hi @FrankZiyar - If you would like some free community help to get going, Integromat has over 9k members in their Facebook group here: Facebook Groups

At a very high level, you need to:

  • Trigger a webhook when the target column changes
  • Have Integromat pull in the value in the column when the webhook gets triggered
  • Have Integromat search all rows on the board for the same value in that column, in a different row
  • Have Integromat push back the “exists” value into a different column if it’s found

Or you can set up a consultation with a partner like us if you are interested in hiring someone to help you do more with monday․com: Book Polished Geek: more with monday.com

#6

hello @FrankZiyar and happy new year all… :slightly_smiling_face:

I dont know anything about Integromat .

but this would be fairly straight forward. If you use the “Uppercase” example integration tutorial as a base. Note: I didnt test this so its not a working solution. Just the building blocks.

Trigger on your target column. (as stated.)

Use the Monday sdk with graphql. in my example “dept” is the target.
you will have to set this up in your code. below is just from playground.

query {
boards (ids: 8825xxxx6) {items {id name
column_values (ids: “dept”) { value }
} } }

Then in your code

      let targetlist =  [ ];
  data.forEach(item => {
    targetlist.push(item.column_values[0])
  })

  let seen = new Set();
var hasDuplicates = targetlist.some(function(currentObject) {
    return seen.size === seen.add(currentObject.value).size;
});

then “hasDuplicates” needs to be false if your target is good. or replace text with your warning text on true …

hope that helps.

cheers.

Eric.

#7

Hi Eric!
Thank you for your idea!
I will surely try to use this code! :+1: :+1: