- What is your app called? - vLookApp. - Why did you build this app? - Because I needed this tool. - What does your app do? - Exactly what it says, a Lookup function across Monday boards. - What example use cases and workflows does this app apply to? - If you need to lookup a value from one column in a different columns, and return a specific value from this row (just like in other spreadsheets). - Who are you? Are you a monday partner? My name is Yogev, and I’m not sure what a Monday Partner is. - How can users use your app? - Just install it here and follow the recipe explanation bellow. - Are there any dependencies (eg: must have an enterprise subscription to X tool) - No. - Does it have a cost? - No.
Howdy! Just installed this, but am having trouble accessing it within the automations view. Is there a certain set of steps I need to take to find the vlookup functionality? Thanks!
Look up a value in client SKU in Artwork, column (Name), Return value from Status and mirror it to Approval
Artwork is the board where my client is a guest and confirms via a status column when each tag is approved or under review. I want that response to show up in a board where my colleagues are (Approval column) so they can see as soon as the same tag is approved within that second board.
The column Name is the first column from the left, I don’t see any other way to reference it. Nothing is showing up.
Unfortunately, what you refer to as “the first column from the left” in not actually a column, it’s the Item Name, this is how Monday boards are designed, unlike in an excel spreadsheet.
Notice that you cannot move or delete it, for the exact same reason.
You can use this app with any other regular column though.
Hope this helps.
If I were to move it to the second column rather than trying to use the first, what would I need to correct?
I think I am interpreting the recipe wrong.
Hey @Yoggie I love the app! However, is there a way to have the “column” that contains the value I want to look up/look for to be the Item’s name?
same for the target I am looking it up in? Like, I want to use it for a central database of clients, so when I make a new board for a specific event that some clients might be interested in then I can just copy in their names and it instantly mirrors in all the relevant contact details.
I’m trying to have Vlookup replace the mirrors columns of monday, I though I could use the link board column and then use Vlookup to update the status of my columns (instead of having mirrors columns). However I see that the linkboard column is also not supported (VL1 in my screenshot) :
Unfortunately Monday don’t store the value of a formula, so automations and integrations do not apply to it.
They might change it in the future, the app is set to be able to handle function columns once they do.
I’ve been trying out a few tests and it doesn’t seem to be working for me. When I try to select the Status and Target Status I get a dropdown that allows me to input a text rather than selecting the specific columns. Should I input the name of the column or the column number?
