We have created two custom fields for Sanctuary and Region. Is there a way that the region field can be auto populated based on the sanctuary response that is selected from the drop down menu list?
Thanks
We have created two custom fields for Sanctuary and Region. Is there a way that the region field can be auto populated based on the sanctuary response that is selected from the drop down menu list?
Thanks
Hello @D_H80, David
Welcome to the community. From your question it looks like you are talking about custom fields in an integration app. You can setup dependencies between custom fields so the region dropdown list gets populated by the value chosen in the sanctuary field.
To do that you need to populate the region field from within the app. Are you looking how to setup such a dependency?
Hi Bas, thanks for your reply and suggestion.
I had a look at the dependancy option before I posted on here but I couldnβt find one that had an βIf A add XXXX, if B add XXXX, if C and XXXX etc.β option within the same board. That said, Iβm new to Monday so it might be there and perhaps I missed it or missundstood itβs meaning.
We have created a drop down list for the region and the sanctuary already, so I am hoping that there is a simple way to connect the two.
hi David,
It is possible, but the question is: is it simple?
Where / how did you created those drop down lists? In the board (column) itself, in the customfield builder or are you building an app yourself?
So basically, there doesnβt seem to be no internal way to let one field be a copy or result of a formula from another field in the same row without external tools like Integromat. Is that correct? It would be hugely helpful if that was a native automation.
Hi Bas
We created a drop down column and then added in the list options we want to display and then savd the column as a template so that we can add them to all boards across the organisation.
Itβs never simple, but then very few things in life are, especially the ones that are worth pursuing!
Hi David,
Unfortunately in this scenario it is not possible to auto-populate one column based on the selection made in another column. I was a little confused by the term custom fields as this exact term is also used in integrations developed by 3rd parties.
Thanks Bas
I have managed to do it (with the help of Monday support team, who were great) with an IF,OR,SEARCH formula. It doesnβt fill an existing column, rather it fills in the answer in the formula column itself.
Might be handy to know if you ever need something simliar yourself.
Thanks for your input.
The below formula works when only one response is required.
IF({Dropdown#Labels}=β1β,βOutput 1β,
IF({Dropdown#Labels}=β2β,βOutput 2β,
IF({Dropdown#Labels}=β3β,βOutput 3β,"")))
Make sure to edit the formula so that the column names/values match the ones on your board so that {Dropdown#Labels} would need Dropdown replaced with the values from your list and Output would be the name of the column that is being populated. The formula column itself is where the answers will populate, rather than filling in another column, so you can just change the formula column header as needed.
e.g.
IF({Colour#Labels}=β1β,βRedβ,
IF({Colour#Labels}=β2β,βBlueβ,
Hope this makes sense.
If you need a formula that takes into account multiple selections I have one of those too, so just let me know.
Got it. Thanks. I was confused by your description ββ¦ IF,OR,SEARCHβ¦β. I was expecting something more.
Well, the ful code we ended up using enabled us to use multiple selections and was as follows, (iβve just replaced our drop down options numbers for privacy ).
CONCATENATE(IF(OR(SEARCH(β1β,{Sanctuary#Labels},0)>0,SEARCH(β2β,{Sanctuary#Labels},0)>0,SEARCH(β2β,{Sanctuary#Labels},0)>0,
SEARCH(β4β,{Sanctuary#Labels},0)>0,SEARCH(β5β,{Sanctuary#Labels},0)>0,SEARCH(β6β,{Sanctuary#Labels},0)>0,SEARCH(β7β,{Sanctuary#Labels},0)>0,SEARCH(β8β,{Sanctuary#Labels},0)>0,SEARCH(β9β,{Sanctuary#Labels},0)>0,SEARCH(β10β,{Sanctuary#Labels},0)>0)," North East. β),
IF(OR(SEARCH(β11β,{Sanctuary#Labels},0)>0,SEARCH(β12β,{Sanctuary#Labels},0)>0,SEARCH(β13β,{Sanctuary#Labels},0)>0,SEARCH(β14β,{Sanctuary#Labels},0)>0,SEARCH(β15β,{Sanctuary#Labels},0)>0,SEARCH(β16β,{Sanctuary#Labels},0)>0),β Central. β),
IF(OR(SEARCH(β17β,{Sanctuary#Labels},0)>0,SEARCH(β18β,{Sanctuary#Labels},0)>0,SEARCH(β19β,{Sanctuary#Labels},0)>0,SEARCH(β20β,{Sanctuary#Labels},0)>0),β South East. β),
IF(OR(SEARCH(β21β,{Sanctuary#Labels},0)>0,SEARCH(β22β,{Sanctuary#Labels},0)>0,
SEARCH(β23β,{Sanctuary#Labels},0)>0,SEARCH(β24β,{Sanctuary#Labels},0)>0,
SEARCH(β25β,{Sanctuary#Labels},0)>0,SEARCH(β26β,{Sanctuary#Labels},0)>0,SEARCH(β27β,{Sanctuary#Labels},0)>0),β North West. β),
IF(OR(SEARCH(β28β,{Sanctuary#Labels},0)>0,SEARCH(β29β,Sanctuary#Labels},0)>0,SEARCH(β30β,{Sanctuary#Labels},0)>0,SEARCH(β31β,{Sanctuary#Labels},0)>0),β South West. "))
Is that more what you had in mind?
What about switch to populate values ir text fields? This one looks at values in columns to create an average towards 100% from sub fieldsβ¦
ROUND(
(
SWITCH({Discovery},
"Idea",0,
"Discussion",25,
"Stuck",50,
"Ongoing",75,
"Done",100,
0)
+SWITCH({Docs},
"Untouched",0,
"Stuck",25,
"Working on it",50,
"Ongoing",75,
"Done",100,
0)
+SWITCH({Present},
"Untouched",0,
"Stuck",25,
"Presentation ready",50,
"TPC/DPC",75,
"Presented FOH",100,
0)
)/3
,0)
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.