I’m using API v2 with an Excel query for basic analysis on a board that Monday formulas appear unable to accomplish. I have a people column that I am trying to compare with a voting column. I am looking to compare the users assigned via the people column with the list of users who have voted with the vote column.
I am trying to use the API to gather a list of people who have voted with the vote column. But, I cannot seem to find a way to pull a list of users who have voted. My mind went to the formula column because it can be used to pull up this list. Unfortunately, it does not appear to be possible to pull formula information via the API. I’m looking forward to any suggestions you have.