Add Ons and Integrations
Add Ons and Integrations
Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.
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
-
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:
Answers
-
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:
-
Thank you, I will try that instead!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
