I’m trying to update values from a Microsoft Office 365 Excel to Monday via Make.
I’m starting with “Watch worksheet rows” and getting the values, then I want to update specific values to a Monday Item (using the “update column values of a specific item” function".
My problem is knowing the Item ID of the the Monday board, and making it dynamic.
On my Excel I have a field which equals to the “Item” on Monday. I used it as the Item ID, but getting an error since I guess the Name coming from the Excel is not the Item ID.
How do I update an item specific column value if all I have is the item name and not the Item ID? (-: