I’m trying to populate a column on Monday.com from data that lives in a row on a Google Spreadsheet.
In a perfect world, a new column would be created in Monday.com every time a new row is added to the Google Spreadsheet. However, the issue I’m running into the most is trying to account for a dynamic Column ID.
When you map the Column ID to a data point from the Google Sheet, the options to select a Label disappear. How do you format the “Any Value” field to accept a conditional statement?
This is the option it gives me:
And this is what I’m trying to replicate using a mapped field for the Column ID: