Issue with First Row & Boolean Field using Excel Query


I'm querying data from a Smartsheet by using the Read Only - HTML publish link. The first row has entries of "Collaboration powered by Smartsheet | Report Abuse" in each field and the query is not showing the boolean / checkbox entries in my "For Timeline" column. I tried removing the first row in the query editor and changing the format of the "For Timeline" column to be True / False, but there are no values appearing column B where I would expect YES / NO values. What am I doing wrong?


Best Answer

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭
    Answer ✓

    I don't believe it's possible with the Read Only - HTML link. It doesn't look like you can edit anything in the first Source step, and already in the second step it's extracting blank values, not even null.

    Do you have access to the source sheet to import via API instead of the HTML link? Using the Apps & Integrations API Access you can pull in boolean values:

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner